Run code only if activesheet.name is Sheet 1 or Sheet 2

[Ironman]

Hi

I have the following code:

If ActiveSheet.Name <> "Training Log" Then Exit Sub

I'm trying to amend this so that the code will also run if the active sheet is called "Analysis" (without the commas)

I've tried

If ActiveSheet.Name <> "Training Log" or "Analysis" Then Exit Sub

but this errors.

Can you help me please?

Thank you

 

[steve the fish]

Try:

If ActiveSheet.Name <> "Training Log" And ActiveSheet.Name <> "Analysis" Then Exit Sub

You need both conditions to be true so you need and rather than or.

 

[tyija1995]

Hi Ironman,

Try this:

If ActiveSheet.Name <> "Training Log" And ActiveSheet.Name <> "Analysis" Then Exit Sub
MsgBox "Hi"

You should see "Hi" if you are in training log or analysis worksheet, otherwise nothing.

 

[Ironman]

Perfect! Many thanks!

 

[tyija1995]

Glad we could help!
Apologies for the duplicated code, I was mid-typing up the post when Steve replied so never saw his reply before I sent off mine :D