Archive of Mr Excel Message Board
Back to Excel VBA archive index
Back to archive home
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! :)
| Check out our Excel VBA Resources
|
 |
 |
 |
 |
 |
Re: A VBA equivilent of "shift, ctl + down"?
Posted by Dank on January 04, 2002 4:27 AM
Range(Selection, Selection.End(xlDown)).Select
HTH,
Daniel.
Re: A VBA equivilent of
Posted by Dave on January 04, 2002 6:08 AM
Thanks
Posted by Dave on January 04, 2002 6:12 AM
Thanks again for your help, it works a treat!
Dave
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.