Select Until Empty Cell From VBA Code

[Guest]

Hi-

I am new to Excel programming and want to do a select a range starting from
a cell down the column until there is an empty cell from my VBA code.

This is the equivalent of selecting a cell on the worsheet and pressing
ctrl+shift+down arrow.

Can anyone post sample code for how to do this?

Thank you,

Eric

 

[Guest]

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

will mimic the crtl+shift+down arrow.

Hope this helps

Neil
www.nwarwick.co.uk