Macro to Find and Delete Rows
Posted by Tyler on July 17, 2001 1:46 PM
I'm new to VBA and would like some help with a macro. The sheet that needs to be 'parsed' has cells that contain X, but each sheet can have a different number of cells that contain X. Here is what I tried.
Cells.Find(What:="X", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
Loop Until Null
The 'Loop Until Null' statement was my feeble attempt to get the loop to end when no more occurrences of 'X' are found. I'd appreciate any help. Thanks, Tyler