Select to the bottom of a Column

I often times find myself pushing ctrl+shift+Down in order to select to the bottom of a column. I want to select all cells with text but sometimes there are empty cells in between and of course then it won't select to the bottom. I tried to build this macro in order to select a range to the bottom-most cell that isn't empty, skipping the blank cells. Doesn't work. Any help?

Please Login or Register  to view this content.

Yes!!!!! Wouldn't have figured that out myself. Thanks.