I think the problem is with the = symbol before the word Updated. Excel is
going to try to evaluate that as a formula. Either remove that = or add an
apostrophe before it to force Text Formatting.

HTH,
Elkar


"John" wrote:

what is wrong with this one... noob question

Sheets("CP").Range("a5") = "=Updated on " & Now

Thanks for the help