I have this line of code as part of a macro

ActiveCell.FormulaR1C1 = "=""Last Updated: ""&TEXT(NOW(),""dd-mmm-yyyy"")"

but what I need is to put the actual value ot the NOW() function into the cell rather than the function itself. this is because putting the function itself in the cell means that cell is always equal to NOW, but what I want is that cell to be equal to the date this macro was run, so it has to be the value and not the function.

anyone?

thanks