one line!!!

[John]

what is wrong with this one... noob question

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

Thanks for the help

[Paul B]

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" <[email protected]> wrote in message
news:[email protected]...
> what is wrong with this one... noob question
>
> Sheets("CP").Range("a5") = "=Updated on " & Now
>
> Thanks for the help

[Elkar]

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

[excelent]

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

[Don Guillett]

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
[email protected]
"John" <[email protected]> wrote in message
news:[email protected]...
> what is wrong with this one... noob question
>
> Sheets("CP").Range("a5") = "=Updated on " & Now
>
> Thanks for the help

[John]

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
> [email protected]
> "John" <[email protected]> wrote in message
> news:[email protected]...
> > what is wrong with this one... noob question
> >
> > Sheets("CP").Range("a5") = "=Updated on " & Now
> >
> > Thanks for the help
>
>
>

[Don Guillett]

glad to help

--
Don Guillett
SalesAid Software
[email protected]
"John" <[email protected]> wrote in message
news:[email protected]...
> 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
>> [email protected]
>> "John" <[email protected]> wrote in message
>> news:[email protected]...
>> > what is wrong with this one... noob question
>> >
>> > Sheets("CP").Range("a5") = "=Updated on " & Now
>> >
>> > Thanks for the help
>>
>>
>>