Delete Rows Based On Content

  • Thread starter Thread starter halem2
  • Start date Start date
H

halem2

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??? :confused: :eek
 
It's looking for the literal text OPERATOR ID. Is that what you want?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and paste 1
Combine deletion Criteria 2
Evaluating Empty Cells 3
Delete rows based on contents of Col A 0
Compile Error: Expected:( 2
Delete rows where cells contain various criteria 1
Nested Do Until Loop 4
Set Print Area with Dynamic Start Point 2

Back
Top