Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Select NON blank cells
I want to click on a cell and have only the cells that contain data in that
colum to be visible.(Lets assume I click in cell b5, then I want only the non blank cells in col 5 to be visible)(ie the same as using "SELECT all NON BLANK cells) But I want a macro to do this. Any help will be appreciated Thanks Ian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically add "0" to blank cells without a formula in the cel. | Excel Worksheet Functions | |||
Blank Rows from Merged Cells in Drop Down Menu | Excel Discussion (Misc queries) | |||
Generating truly blank cells | Excel Worksheet Functions | |||
enter numbers in blank cells | Excel Worksheet Functions | |||
blank cells | Excel Discussion (Misc queries) |