Do not run macro on certain sheets...

[cmhoz]

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!!

 

[acw]

Hi

How about something like

for each ws in worksheets
  select case ws.name
   case "name1","name2","name3"
    exit sub
    case else
   do your stuff
 end select

next ws

Tony

 

[cmhoz]

yep... beautiful.

Thanks... helps to have an extra brain once in a while!