Looping Macro Across All Sheet with Exceptions

Hi,

I've got some simple code, that I can get to work on one sheet quite well. It removes any rows with date in Column "K" that are over 180 days in the future. I need to run it across all the sheets in my workbook, with the exceptions of "Master", "Exceptions", "Unlimited" and "Closed"

I've tried this:

Please Login or Register  to view this content.

It still works on the first sheet, but won't loop through the book. Any help would be great.

Perfect!!. Works a treat. Was nearly there!

Originally Posted by gabbana

Perfect!!. Works a treat. Was nearly there!

Spoke too soon, it's running on the excluded sheets.

Originally Posted by Norie

Change the Or(s) in the If statement to And(s).

I'd just worked that out! Thank you very much for your help.