one line!!!
 

what is wrong with this one... noob question

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

Thanks for the help

one line!!!
 

John, try this,

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


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"John" wrote in message
...
what is wrong with this one... noob question

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

Thanks for the help

one line!!!
 

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

one line!!!
 

try
Sheets("CP").Range("a5") = " =Updated on " & Now
and dont ask :-)



"John" skrev:

what is wrong with this one... noob question

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

Thanks for the help

one line!!!
 

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

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

one line!!!
 

glad to help

--
Don Guillett
SalesAid Software

"John" wrote in message
...
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