Hi Navymagirl, welcome to the forum.
Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to EDIT that post above and put code tags around that code you used. Like this:
Notice the underlined addition to the second macro? That macro was already doing a test to make sure the ws wasn't the "Report" sheet, just add as many other tests as you need and separate them with an OR statement.
Now remember, you must edit your post above and put code tags around the code.
Bookmarks