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