View Single Post
 
Old 12-21-2012, 11:46 PM
Astacus Astacus is offline Windows XP Office XP
Novice
 
Join Date: Dec 2012
Posts: 9
Astacus is on a distinguished road
Default

I suspect I may be missing your problem. You do want the user to select it, right? If so, there are other ways to select areas, such as using Shift with arrow keys and PgDn, or entering "B53:B150" in the address box.

But if you want to do it in VBA, you can do that with:
Range("B53:B150").Select
Reply With Quote