April 2006
Beginner
1114 pages
98h 16m
English
range.End([Direction])
Returns a Range object that represents the cell at the end a region of cells containing the specified range, in the specified direction. The following code selects the cell at the bottom end of the region containing cell A2:
Dim r As Range
Set r = ActiveSheet.Range("A2")
r.End(xlDown).SelectRead now
Unlock full access