Okay...
I have a macro (or will when i write it!) that loops through each worksheet in the file and runs a macro. This is fine.
However, there a 3 sheets in the files that I want the macro to NOT run on.
So, I was thinking that I would do a select case for these three that lead to and exit sub and a case else that runs the macro.
I'm drawing a blank on one little bit - the syntax to use to determine the name of the sheet...
eg: select case sheets
case sheets("sheet1")
exit sub
select case sheets doesn't work... and apparently neither does my brain!
Thanks!!
I have a macro (or will when i write it!) that loops through each worksheet in the file and runs a macro. This is fine.
However, there a 3 sheets in the files that I want the macro to NOT run on.
So, I was thinking that I would do a select case for these three that lead to and exit sub and a case else that runs the macro.
I'm drawing a blank on one little bit - the syntax to use to determine the name of the sheet...
eg: select case sheets
case sheets("sheet1")
exit sub
select case sheets doesn't work... and apparently neither does my brain!
Thanks!!