| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code
Hi
My sheet is laid out as follows, A1 Unit1 A5 Unit2 A9 Unit3 etc. through A21Unit6 As a new unit is added the cellis changed to the actual unit name. The 3 lines after each unit are associated with that particular unit.I need code that when run will hide the rows for any units that havent been named. Example A1= Dog A5 = Cat units 3-6 have not been added. When the macro is run I want to hide rows 9-24. I hope I have provided enough information All help would be greatly appreciated. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| Generic protect/unprotect code through buttons and code? | Excel Programming | |||
| How to make a button VBA code reference other VBA code subroutines??? | Excel Programming | |||
| stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
Threaded Mode
