I am trying to write an IF statement that has a certain criteria in Column C AND the criteria of the first two characters in each cell in column D are satisfied, and then to delete the entire row if it is true.
What I have so far is
But I am getting an Invalid or unqualified reference error.
Please Login or Register to view this content.
Thanks in advance for your help
Try this code
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks arlu1201. Worked perfectly. I guess I didn't know how to preselect the rows to make the formula work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks