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

--
Dave_2k
-----------------------------------------------------------------------
Dave_2k5's Profile: http://www.excelforum.com/member.php...fo&userid=1966
View this thread: http://www.excelforum.com/showthread.php?threadid=47414

not equal to is "<"

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


HT

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=47414

Thanks for that...

I just couldn't remember!!

Cheer

--
Dave_2k
-----------------------------------------------------------------------
Dave_2k5's Profile: http://www.excelforum.com/member.php...fo&userid=1966
View this thread: http://www.excelforum.com/showthread.php?threadid=47414