Posted to microsoft.public.excel.programming

Shorty[_3_] Shorty[_3_] is offline

external usenet poster

Posts: 19

Quotes in Macro Formula

Hi
this should be a quick one! im trying to put a formula in a cell ie
ActiveCell.Formula = "=CONCATENATE(TEXT(A1,"yyyy/mm/dd"))"

However as i have to put double quotes in for the date format excel
thinks it is at the end of the line, how can i put in the double quotes
without this happening?

ActiveCell.Formula = "=CONCATENATE(TEXT(A1," & chr0022 & "yyyy/mm/dd"
& chr0022 & "))"

or something like this?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
change straight quotes to curly quotes	callico	Excel Discussion (Misc queries)	2	June 22nd 07 10:23 PM
Quotes in .formula calcs	Paulymon	Excel Programming	1	February 28th 06 11:14 PM
Quotes in formula	Kevin	Excel Programming	1	December 2nd 03 05:53 PM
Formula with quotes and ampersand	Neil[_11_]	Excel Programming	3	November 10th 03 07:49 AM
Excel macro to get stock quotes off the www	Bob Benjamin	Excel Programming	1	November 3rd 03 03:39 AM

All times are GMT +1. The time now is 11:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us