I have a column of numerical values and random empty or null value
cells. I want to compress the column so I only retain the numerical
values without losing their sequence. Ideally if there was a function
like "delete row" where you check for null value cells and delete the
appropriate row. Macros won't work because the column sequence changes
whenever worksheet is activated

Thank you


--
Harrymo
------------------------------------------------------------------------
Harrymo's Profile: http://www.excelforum.com/member.php...o&userid=30620
View this thread: http://www.excelforum.com/showthread...hreadid=502746

Try this:

Select the cells from top of the list to the bottom of the list
EditGo ToClick:Special CellsSelect:Blanks....Click [OK]

EditDeleteEntire Row

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=502746

Set up autofilters and select (blanks) from the pull-down list on the
column. Then highlight all the displayed rows which have been filtered
(row indicator shows as blue) and Edit | Delete Row. Select (All) from
the pull-down filter list and you will have what you have asked for.

Hope this helps.

Pete

Hi Pete,

Thank you for your prompt reply. Solved problem


Best Regards,

Harry


--
Harrymo
------------------------------------------------------------------------
Harrymo's Profile: http://www.excelforum.com/member.php...o&userid=30620
View this thread: http://www.excelforum.com/showthread...hreadid=502746