Thank You

That's my problem I typed it incorrectly



-----Original Message-----
hard to tell. $a$f1278 isn't a valid address you
could mean

af1278
a1278
f1278

You don't need $ in VBA for an argument to Range

You could do

If ActiveCell.Address = "$AF$1278" then

You do need the dollar signs here because the comparison
is to a string that
would match the results of the Address argument.

--
Regards,
Tom Ogilvy

wrote in message
...
Hello,

Is there a better way to start this if statement - it is
not working for me

If ActiveCell.Address = Range("$a$f1278").Address Then


.