Automatically hide column or row if a cell value meets criteria
I need a macro or formula that will automatically hide a row or column
based on an entry in a specific cell.
For instance, =IF(D2="",*****,D2)
with ***** being the formula
or =IF(C3=0,Rows("3:3").Select,Selection.EntireRow.Hi dden=True,C3)
of course this isn't working but something like this would be great
Thanks so much for your continued assistance.
Don
|