How do I set the selected range equal to a variable that I can call and use later
Range(Selection, Selection.End(xlDown)).Select
How do I set the selected range equal to a variable that I can call and use later
Range(Selection, Selection.End(xlDown)).Select
Dim YourRange As Range Set YourRange = Range(Selection, Selection.End(xlDown))
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Yes. But you need to have the selected a cell that has other cells below it, for example, B5:B11.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks