If you ignore this line in post #4
Quote:
|
any ideas how to use an xlToBottom, but selecting all cells between the two ranges? In example B2:F2
|
And assuming the active sheet is the one you want to work on and assuming row 2 is the row you want to find the end of,
I think this answers what you've asked
Code:
Sub Test()
Dim c As Long
c = Cells(2, Columns.Count).End(xlToLeft).Column
Range(Cells(2, c + 1), Cells(Rows.Count, c).End(xlUp).Offset(0, 1)).Select
End Sub
Seeing this is a single range in an unknown column, how does
example B2:F2 relate ?