Hi folks:
I'm tryint to build a code that would select a cell, check if th
content matches one of two options and if so, move down to the nex
cell, else delete the row. this is what I have:
Do
If ActiveCell = "OPERATOR ID" Or ActiveCell = "JC" Then
ActiveCell.Offset(1, 0).Select
Else: Selection.EntireRow.Delete
End If
Loop Until ActiveCell = "*"
It's working but only for the "JC" not the Op ID. All cells ar
formatted as text.
Any thoughts???
:eek
--
halem
-----------------------------------------------------------------------
halem2's Profile:
http://www.excelforum.com/member.php...nfo&userid=993
View this thread:
http://www.excelforum.com/showthread.php?threadid=26848