Select Activecell and 65 Rows to the Right
But, if you wanted to use Offset and Resize, that could be done quite
compactly...
Sub asdf()
Cells(Rows.Count, "A").End(xlUp).Offset(, 5).Resize(1, 65).Select
End Sub
--
Rick (MVP - Excel)
"Gary''s Student" wrote in message
...
Neither the move 5 or the resize is necessary:
Sub asdf()
n = Cells(Rows.Count, "A").End(xlUp).Row
Range("F" & n & ":BR" & n).Select
End Sub
--
Gary''s Student - gsnu200822
|