Posts by LSusiee

Hi!
It looks like it deleted rows that contained Inserted or ClassID and those are the ones I need

Hi!
Yes, I just need the rows that say Inserted or ClassID, everything else can be deleted. I have attached the document without the personal information so some columns will be empty. I've also attached a screenshot of what the end result should look like.

Thanks so much for your help!

Hello,

I am currently working on a macro that will scan columns "E" and "I" and if they do not contain "Inserted" or "ClassID" the row should be deleted. I've tried multiple different variations but can't seem to get it right.. below is what I have so far:

Sub EvaluateD()
Dim i, LastRow
Dim UserIDModLog

UserIDModLog = ActiveSheet.Name

LastRow = UserIDModLog(Rows.Count).End(xlUp).Row
For i = LastRow To 1 Step -1
If UserIDModLog.Value <> "Inserted" Or "ClassID" Then
Else
UserIDModLog.EntireRow.Delete
End If
Next i
End Sub

Help

Hello,

I am currently working on a macro that will scan columns "E" and "I" and if they do not contain "Inserted" or "ClassID" the row should be deleted. I've tried multiple different variations but can't seem to get it right.. below is what I have so far:

Sub EvaluateD()
Dim i, LastRow
Dim UserIDModLog

UserIDModLog = ActiveSheet.Name

LastRow = UserIDModLog(Rows.Count).End(xlUp).Row
For i = LastRow To 1 Step -1
If UserIDModLog.Value <> "Inserted" Or "ClassID" Then
Else
UserIDModLog.EntireRow.Delete
End If
Next i
End Sub

Help