Fastest way to select large range (e.g. B3:F1002)?
You could try a small macro:
Sub Test()
with selection
.cells(.cells.count).activate
end with
End Sub
and assign it to a button on your toolbar.
" wrote:
On Aug 30, 8:19 pm, "Ron Coderre"
wrote:
Type B3:F1002 in the Name Box....Press [Enter]
or
[F5]...Type B3:F1002....Press [Enter]
Does that help?
Yup! Thanks RobN and Ron. I discovered that myself; but verifying it
was tricky because paging down seems to deselect the range. The way I
could get to the end (lower-right) of the selected range was to scroll
down and right.
(Of course, I might have selected a smaller range; less scrolling to
do.)
That's okay. But I'm curious: is there any way to get to the lower-
right corner of the selected range without deselecting the range?
|