IF EMPTY(.value) OR ISNULL(.value) .value=DATE() ENDIFand ISNULL does not recognize cell value ".NULL." as .null.
WITH oExcel * .Range( "C4", .ActiveCell.SpecialCells(11) ).Select With .selection.cells IF ISNULL(.value) .value = DATE() ENDIF Endwith * ENDWITHand if I try:
IF .value = ".NULL."then I am getting error of invalid operator ... Any help ?