Reference Range for Sheet Names

[erock24]

I am using the following code to exclude a macro from running on some sheets. Is it possible to reference the sheet names from range M2:down for the ones I want to exclude. This way if I add a sheet and I don't want the code to run on it I can just type the name in the range.

Thank you for your time ane help.

Please Login or Register  to view this content.

[royUK]

This will work on each sheet named in Column M of the activesheet.

Please Login or Register  to view this content.

[erock24]

Works perfect....thank you.

[royUK]

Thanks for the feedback