Not equal to

[Dave_2k5]

I have a problem which I hope can be resolved quickly:

I have a piece of code as follows:

If ActiveCell.Value = Range("data!G4") Then ...

What the active cells value is and the value in ("data!G4") does no
matter.

What I wan to be able to do is say

If ActiveCell.Value

NOT EQUAL T

Range("data!G4") Then

but I cannot find out how to write not equal to!!!


Cheers,

Dav

 

[swatsp0p]

not equal to is "<>"

If ActiveCell.Value <> Range("data!G4") Then ...


HT

 

[Dave_2k5]

Thanks for that...

I just couldn't remember!!

Cheer