One way wothout having to use a macro would be to do Data Filter
AutoFilter and on column "type" choose Custom Does NOT contain Info

This will then show only those rows that do not contain "info" in the "type"
column. To reverse the situation back to normal, just do Data Filter
AutoFilter again......it toggles back.

hth
Vaya con Dios,
Chuck, CABGx3


"Turquoise_dax" wrote:


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