Range

[Guest]

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

 

[Tom Ogilvy]

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.

 

[William]

Hi

Do you mean
If ActiveCell.Address = Range("$af$1278").Address Then

--
XL2002
Regards

William

(e-mail address removed)

| 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

 

[Guest]

Thank You

That's my problem I typed it incorrectly