| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
one line!!!
what is wrong with this one... noob question
Sheets("CP").Range("a5") = "=Updated on " & Now Thanks for the help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a dotted line to a solid line in a line graph | Charts and Charting in Excel | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
| coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
| Macro problem on, Yellowed line - previous line or next line. | Excel Programming | |||
| Reads entire *.txt file into string opposed to a desired line by line input. | Excel Programming | |||
Hybrid Mode
