Range
 

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

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

Range
 

Hi

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

--
XL2002
Regards

William



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

Range
 

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


.