MrExcel Publishing
Your One Stop for Excel Tips & Solutions

A VBA equivilent of "shift, ctl + down"?


Posted by Dave on January 04, 2002 3:55 AM

Is there an equivilent of this keyboard shortcut (to select all the non empty cells below the currant active cell) in VBA and if so, any chance you could tell me?
Cheers! :)


Posted by Dank on January 04, 2002 4:27 AM

Range(Selection, Selection.End(xlDown)).Select

HTH,
Daniel.

Posted by Dave on January 04, 2002 6:08 AM

Re: A VBA equivilent of


Posted by Dave on January 04, 2002 6:12 AM

Thanks

Thanks again for your help, it works a treat!
Dave