Hi,
I'm a beginner and need some help....
How would I write a macro to hide a range of rows If a cell value is zero, then do the same for five additional ranges of rows?
In my words:
If AT214=0, hide rows 214 to 244
and
If AT245=0, hide rows 245 to 278
and
If AT279=0, hide rows 279 to 311
and
If AT312=0, hide rows 312 to 344
and
If AT345=0, hide rows 345 to 377
and
If AT378=0, hide rows 378 to 410
Any help to put me on the right path would be greatly appreciated!
Ben
Brisbane Austraila
Bookmarks