If activesheet

[Paddy1979]

Hello all,

Please can you adivse me on how to write this code.

i'm trying to make the macro check the activesheet name is Good Diff. before executing the rest of the code.

I've tried - If Activesheet = ("Good Diff.") Then

but it dosent work can anybody help.

Thanks in advance

 

[pgc01]

Hi Paddy1979

Try:

If Activesheet.Name = "Good Diff." Then

HTH
PGC

 

[onlyadrafter]

Hello
IF activesheet.name="Good Diff." then

 

[Paddy1979]

cheers,

 

[DominicB]

Good afternoon Paddy1979

Nearly there! Try this :

If ActiveSheet.Name = ("Good Diff.") Then

HTH

DominicB