| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to hide rows with zero in specifc column range
Hello
I have a workbook with multiple sheets. I would like to put together a macro that will hide the rows in a given range on all sheets. For example, on Sheet 1 the range of cells I need to evaluate for zero are C9:63. If any of the cells in the range are zero, I want to hide the corresponding row. So if C11 is zero, row 11 is hidden. I would repeat the macro for the same ranges on Sheet 2, 3, 4,... Any help is appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
| A macro to copy & paste many rows (a range) to the next column .. | New Users to Excel | |||
| How can I get a count of specifc words in a range? | Excel Worksheet Functions | |||
| Macro to Hide rows based on value of column F | Excel Discussion (Misc queries) | |||
| ???Refer to a specifc cell in a named range | Excel Worksheet Functions | |||
Threaded Mode
