|
Posted to microsoft.public.excel.programming
|
|
|
one line!!!
Thank you one and all!
"Don Guillett" wrote:
for a formula in a5
Sheets("CP").Range("a5") = "=Updated on " & Now
Sheets("CP").Range("a5").formula = "=Updated on " & Now()
for a value
Sheets("CP").Range("a5") = "Updated on " & Now
--
Don Guillett
SalesAid Software
"John" wrote in message
...
what is wrong with this one... noob question
Sheets("CP").Range("a5") = "=Updated on " & Now
Thanks for the help
|