Hello,
I'm trying to write a macro to update a report including deleting all rows that do not contain a specific value of TP in column K. I've searched the web and found various suggestions none of which are working for me.
Below is one of the examples. Any ideas?
'If Application.CountIf(Range("K:K"), 0) <> "TP" Then
'Rows(3).Resize(3).Delete
'End If
Moderator Note: Please read the forum rules and add code tags whenever you post code. Because you are new to the forum, I have added them for you today.
Bookmarks