Trying to delete some rows if conditions met or do nothing if not met

I am trying to make a tracking for people on plans, with weekly follow ups. Each weekly follow up is recorded as a separate line entry, so they can be displayed in a box as a filtered list. This part works great.

Once someone gets finished with their plan, I mark "exited" in a few of places on two worksheets. The one is the master list of who is on a plan, and the second is on the list of weekly followups. Each of their entries gets the "exited" mark. This part also works great.

Where I am running into problem is when the time comes to actually remove the ones with the "exited" mark to clean up my list. I found a code that does what I was looking for, and modified it to do the deleting part based on the presence of "exited". The problem comes if no one says "Exited" of course. Unfortunately, I do not understand the code that I stole enough to fix it.

So the question is, how can I make this do absolutely nothing if no columns say "Exited", except perhaps a msgBox to say "all clear"

Any help would be appreciated, and I apologize in advance for my inept follow-up questions.

BobR

Please Login or Register  to view this content.

Hi,

you can always check if rng1 and rng2 is not nothing, and only then proceed (in red) (untested):

Please Login or Register  to view this content.

Hope this helps.

Rgs,
berlan

Thank you Theo and Berlan. I am going to sleep on this tonight, and will look at them tomorrow after I am rested. They are both certainly more elegant than what I was thinking.

I figured if nothing else, I could add "Exited" below the bottom row at the top of the subroutine, so that there was something to find.

Thank you both!

BobR