Selection

[Richard]

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]

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.

 

[NoodNutt]

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