View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maax Maax is offline
external usenet poster
 
Posts: 12
Default macro to hide all rows that have a cell value of "complete"

Hello all, I wonder if it is possible to create a macro that would toggle
rows from hidden to unhidden? I would like the button to hide all rows that
have a particular cell as "complete". If this requires 2 seperate buttons
that is not a problem.
I think i may need to have a range in for the row (A1 to M1 for example) as
i have some data already hidden beyond M1 (used in drop down lists).

any help would be much appreciated.

thanks