>Hi,
>Another thing; I found the way to change values in selected range but Excel does not recognize Empty ...
>

>IF EMPTY(.value) OR ISNULL(.value)
>   .value=DATE()
>ENDIF
>

>
>
>and 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
>     *
>ENDWITH
>

See the example of how to clear cells in my previous reply.



>
>
>and if I try:

IF  .value = ".NULL."

then I am getting error of invalid operator ... Any help ?

It is not valid syntax for NULLs; must be: IF isnull(.value) .....


>Regards, Gojko