View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Turquoise_dax
 
Posts: n/a
Default How to program a macro to hide rows with conditionnal formating


I have a table with various rows, identified, lets say, by the type of
info (Requirements / Guidelines / Info). I want to program a macro (for
a button) to hide all rows that contains "Info" in the "type" column.

I do not want to enter the number of the row in the macro, because if a
row is inserted, the program has to be revised.

I would also need a macro to automatically unhide all rows.

Thanx a lot!


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=553626