Range

G

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
 
T

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.
 
W

William

Hi

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

--
XL2002
Regards

William

[email protected]

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