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