VBA code to clear the contents (or value) of a cell without clearing the formula

I have a formula in one cell (say P4) that displays a date (in dd/mm/yy hh:mm:ss format) based on the value in another cell

In my VBA code I initialise P4 with .ClearContents which clears the cell
BUT takes out the formula

Can anybody help with the correct syntax in VBA to leave the formula intact

Thanks in advance

BazzaBit

The only way I can think of is to change the font colour. so the contents of the cell are hidden.

but you are better of modifying the code something like

Please Login or Register  to view this content.