Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello. I'd like to loop over all rows in a worksheet, and hide those
matching certain criteria. The criteria a 1. Cell in column 'H' equals "PASS" 2. Cell in column 'M' contains the strings "POUT" and "DIFF" I have so far: Sub show_diffs() ' ' Hide all rows except those showing POUT and DIFF ' except for rows with FAIL ' Application.Goto Range("A2") ActiveCell.EntireRow.Select Do While ActiveCell.Value < "" if selection ???????? Selection.EntireRow.Hidden = False ActiveCell.Offset(1, 0).EntireRow.Select Loop End Sub Thanks. Stephen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looping Checkboxes on Worksheet | Excel Programming | |||
looping thru the worksheet | Excel Programming | |||
Looping Through Worksheet | Excel Programming | |||
Only works on One Worksheet, When Looping thru All WS | Excel Programming | |||
Looping through charts in a worksheet | Excel Programming |