Hi Carim
This is pretty well what you had sent me yesterday, except you adjusted the sheet designations on line 7, but that isn't my problem. I've adjusted for that.
My issue is with line 11. Shouldn't we be referring to the main sheet 'Sheet12' which is the actual target? Also shouldn't it be outside of the loop, so it only deletes once? instead of Sheets(i) which mimics the deletions orchestrated in line #10
The code that you sent me in thread #11 had structure that worked, but we're not applying the same here. If you go back to that thread, and compare the event code in that file to what we have now, you'll see what I mean.
in any event I'm getting error "object required" on line 11 either way
Thanks for your patience... Jimmy