Selection

  • Thread starter Thread starter Richard
  • Start date Start date
R

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
 
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.
 
Lets start simple select cell A10. See where it says A10 up to the left of
the "A" column indicator? That's the name box. To select A10:A250, just
type A10:A250 into that name box and press the [Enter] key. If you want to
select the entire rows from row 10 to 250, then just type 10:250 into it and
hit the [Enter] key.
 
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
 
Back
Top