Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide row with empty cells
You can sort or use a macro using specialcells(visible cells)
"Phil Austerberry" wrote in message ... Can someone please help me! I am trying to get my spreadsheet to hide some rows that I choose - when there is a value of zero or nothing in the columns that I have Chosen of that row- not every column. If there is any value in any of the chosen columns, i wish the row to be displayed. If there is no value or zero in ALL of the chosen columns, i wish for the row to be hidden. Is there some sort of way to do this - maybe using macros????? I would appreciate any help on this as soon as possible - please either post a reply here or email me at Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically hide a row if it is empty | Excel Discussion (Misc queries) | |||
Hide the line when cell B is empty | Excel Discussion (Misc queries) | |||
Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
Macro to hide rows with empty cells | Excel Worksheet Functions | |||
Can blank cells created using empty Double-Quotes not be empty?? | Excel Programming |