VBA - Formula generating "Compile error/ Syntax Error"

[arvin]

Hello,

I'm trying to write a macro that will insert a excel formula into a specific cell. When I try to run the macro I receive a compile/ syntax error. I don't understand why as the formula works in excel....

Here is the code (formula only)

Please Login or Register  to view this content.

Here is the Full code

Please Login or Register  to view this content.

Thank you in advance.....

[jasoncw]

Hi arvin,

Whenever you are creating a string in VBA, if you have quotes within the string, you need to double them up:

Please Login or Register  to view this content.

HTH,
Jason

[arvin]

Wow.. ...Thank you very much for that tip ... I was not aware of that. I tried the macro and it works now ...

Thank you again!

[jasoncw]

Great to hear! Please mark the thread as solved.

[arvin]

Marking thread as "solved"

Thank for you all your help