Date Update in a Cell

L

Les

I have a calendar linked to a cell, which contains a formula. The formula won't work unless I click in the command line (as if wanting to edit), and then pressing enter - and then PRESTO the formula updates.

Can anyone help me with this!!

I've tried writing code:-

ActiveCell.FormulaR1C1 = ""
Range("C10").Select
 
Top