Hide Rows per criteria

Giganews Newsgroups
Subject: Hide Rows per criteria
Posted by:  2D Rick (rbrowni…@compuserve.com)
Date: 10 Jan 2007

I need to look thru a range "  Worksheets(1).Range("R4:AI7000")  " row
by row and hide the row if "ICG" is not in any of the 18 cells in that
row. Similar to what AutoFilter does only in VBA.

"ICG" can show up once or twice per row and in any position along the
18 cells.

If "ICG" is found, do nothing and check next row.
If found hide the row.

Once printed I would like to un-hide all rows.

Thanks, Rick

Replies