Hi Howard,

Am Sat, 18 Jan 2014 22:06:35 -0800 (PST) schrieb L. Howard:

If rngC.Value * rngC.Offset(, 1).Value = 99 Then

both cells rngC and rngC.Offset(,1) should be NOT zero to change the
cell value in column 46.
IF you multiply to values and one of them is 0 the result = 0
So it is the same as writing
IF rngc < 0 or rngc.offset(,1) < 0
The muliplication is the substitute for the OR statement above


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2