Thanks
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
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