View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default 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?