| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Code to Hide Rows
Can anyone provide code to hide entire rows if cells contain no data/
values? For example in my chart of accounts, I have 150 accounts. Column A is Budget, B is Actual. If Column B row 76 (Cellb76) has no value, I'd like to hide the entire row. This way, I only see rows with values for the month. Then secondly, if that works easily, can Excel look at both A76 and B76 and if no values hide row? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA code to hide blank rows | Excel Worksheet Functions | |||
| hide code does not hide | Excel Discussion (Misc queries) | |||
| VB Code to hide and unhide rows | Excel Discussion (Misc queries) | |||
| Macro/code to hide rows | Excel Worksheet Functions | |||
| Code for button to hide/unhide rows | Excel Worksheet Functions | |||
Threaded Mode
