Hello folks,
I have a spreadsheet attached as a sample. The columns in use never vary but the number of rows would.
Data is not entered in every cell in the blue range and it is that range I want to select.
I've had a go at some code using current region select and then the Offset function which moves the selection two columns to the right but then includes columns I and J which I don't want. I then tried the resize function but cannot get that to work.
But basically I want to select the region with data entered in columns C to H.
Sub SelectRange() Dim myhours As Range Range("A1").CurrentRegion.Select Set myhours = Range("A1").CurrentRegion myhours.Offset(, 2).Select myhours.Resize(, 2).Select End Sub