Hi I'm using the following formula in a routine:

Range("G11:CX298").Formula = "=IF(AND($DX11<$B11,$G11="".""),$DZ11)"


If the criteria = true then it placecs the value of $DZ11 which is wan
I want.

What do I put in for the false part of the statement if I want to tak
no action? I don't want to clear or change the contents at all if th
condition is false.

Thank

--
Message posted from http://www.ExcelForum.com