Macro to insert forumula?

Chris424 · Nov 8, 2011

Hello,

I would like to enter the following formula into a cell using a macro:

Code:

"=TEXT(WEEKDAY(B5), "ddd")"

However, when I try

Code:

Range("C3").Formula = "=TEXT(WEEKDAY(B5), "ddd")"

It gives a syntax error?

Thanks for any help

Weaver · Nov 8, 2011

Code:

Range("C3").Formula = "=TEXT(WEEKDAY(B5), ""ddd"")"

You have to "quote" the quotes.

Chris424 · Nov 8, 2011

Weaver said:
Code:

Range("C3").Formula = "=TEXT(WEEKDAY(B5), ""ddd"")"

I can't believe it was that simple! Thank you