Jacob, It works perfectly. Anyway FSt1's answer is a work around if I did not
get Jacob's post. Thanks everyone
--
Failing to plan is planning to fail


"Jacob Skaria" wrote:

CTRL+SHIFT+*
Selects the current region around the active cell (the data area enclosed by
blank rows and blank columns).

CTRL+SHIFT+DownArrow
Selects the cells in the same column with data

--
Jacob (MVP - Excel)


"Joe" wrote:

Could anyone tell me what is the shortcut to select the used up cells in a
column?
--
Failing to plan is planning to fail