Automatically Delete Rows that contain a certain word?
Posted by David Morris on January 09, 2002 8:28 AM
I just had someone on the board help me to highlight all the *Total* rows.
Using this VB script:
Dim Cnt As Integer
For Cnt = 1 To 500
If UCase(Range("B" & Cnt)) = "*TOTAL*" Then
Range("A" & Cnt, "N" & Cnt).Interior.ColorIndex = 4
Now, Is there a way to delete rows that contain the word *Total* in column A, but not column b? I am trying to automate some reports that require a ton of formatting each day.
If you would like me to email you a copy of the report to see what I am talking about - please email me.