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!