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 not matter.

What I wan to be able to do is say

If ActiveCell.Value

Not Equal to

Range("data!G4") Then

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


Cheers,

Dave

[swatsp0p]

not equal to is "<>"

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


HTH

[Dave_2k5]

Thanks for that...

I just couldn't remember!!

Cheers