Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to hide blank cells in a range
I have an input sheet that has multiple cells for data input. Not all cells
are used on a monthly basis. I go through and hide the rows with blank input cells. Each month, the cells are not blank, so I can not write a macro to hide row 1-6. Is there a macro that will evaluate the cells in the range and hide all rows that do not have data in the specified cells? Example: If my range is A1:F111 and column D has the input cells, is there a macro that would hide rows 15-20, 28-29, and 43 because the corresponding cells in column D have no data? Thanks Dave |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to hide blank cells in a range
Dave
Record a macro running the autofilter on column D with the criteria as blanks. It maybe you only wanted that feature highlighting and you won't need a macro -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk "Dave" wrote in message ... I have an input sheet that has multiple cells for data input. Not all cells are used on a monthly basis. I go through and hide the rows with blank input cells. Each month, the cells are not blank, so I can not write a macro to hide row 1-6. Is there a macro that will evaluate the cells in the range and hide all rows that do not have data in the specified cells? Example: If my range is A1:F111 and column D has the input cells, is there a macro that would hide rows 15-20, 28-29, and 43 because the corresponding cells in column D have no data? Thanks Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for hiding rows | Excel Discussion (Misc queries) | |||
Macro €“ select all cells in current range | Excel Discussion (Misc queries) | |||
Hide columns & rows that contain "0" or blank in a range of cells | Excel Worksheet Functions | |||
Pivot Table - hide blank cells | Excel Discussion (Misc queries) | |||
Macro to omit blank cells needed | Excel Worksheet Functions |