Hello.

I'm after a little help with how I can run through a list (on a named range) comparing it to the worksheets in the active workbook and delete any worksheets that are not in the workbook AND are not on a list of templates.

I've currently got a function and a sub that will create new worksheets based on the named range and another sub that will delete all worksheets that are not named on a list. I just can't figure out how to merge them, or if it's possible to do it a different way.

Here's what I have:

The function:
Please Login or Register  to view this content.
The sub to add worksheets based on the named range:
Please Login or Register  to view this content.
The sub to delete all worksheets that are not on the list:
Please Login or Register  to view this content.
I think I need to somehow get my named range into the If ws.Name... bit but I can't figure out how.

Thanks for your time and if I've not been clear, please let me know.