View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] DonFlak@gmail.com is offline
external usenet poster
 
Posts: 41
Default 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