Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Selection

3 views
Skip to first unread message

Richard

unread,
May 13, 2007, 7:17:06 PM5/13/07
to
I select row 10, then I want to select from row 10 to row 250. However, I
don't want to drag my mouse all the way to row 250. Is there a short cut
key to do this selection. How something similar about cell A10 to cell
A250?

Thanks


Dave Peterson

unread,
May 13, 2007, 7:19:38 PM5/13/07
to
Edit|goto (F5 or ctrl-g)
type:
10:250
hit enter

Or type
10:250
in the namebox (to the left of the formula bar)
and hit enter.

and you could use A10:A250 instead of 10:250.

--

Dave Peterson

NoodNutt

unread,
Feb 23, 2008, 5:40:39 AM2/23/08
to
Depending on what you are going to do after you have selected your range
10:250 you might consider adding a cmd btn with a code behind it, something
like this:

Sub GrabMyRange()

Range("YourStartCell:YourFinishCell").Select

Then if you want to copy your selected range

Selection.Copy

If you want to copy it to a different sheet

Sheets("YourOtherSheet").Select
Range("PastingPointCell").Select
ActiveSheet.Paste

End Sub

Once you have created you cmd btn and labelled whatever you want to call it

R click | Assign Macro | Select your macro | OK

HTH
Mark


0 new messages