|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
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.