Select Until Empty Cell From VBA Code

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

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

will mimic the crtl+shift+down arrow.

Hope this helps

Neil
www.nwarwick.co.uk

"Eric" wrote:

> 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