VBA Formula Syntax Error

[bilbo85]

Hello,

Could someone help to identify the issue with the below please? It says there is a syntax error. I'm sure it's something simple like an issue with the quotes but I can't seem to get it to work.

Please Login or Register  to view this content.

I am trying to get it to appear like this:

"xxxxxx-xxxxxx","text","text","text","2020/08/17"

Thanks!

[GC Excel]

Hi,

I think this is what you need:

Please Login or Register  to view this content.

[bilbo85]

I still can't get that to work. How do you write it with .formula too and quotes around each item (yours is missing the start and ending quotes)?

[GC Excel]

Oups, my bad.
this would work:

Please Login or Register  to view this content.

one way to do it is to write the formula in a cell, then go in the VBE editor, in the immediate window (CTRL + G) and type debug.print activecell.formula
this will give you the result of my previous code. The you have do replace all single quote " by double quotes "" and add the starting and ending quotes.

[bilbo85]

Thanks for this but now I just get #VALUE error.

Here is the formula that works when typing directly in the cell. So would I have to replace every single quote here with 2 quotes? I still couldn't get that to work.

Please Login or Register  to view this content.

[romperstomper]

It would be:

Please Login or Register  to view this content.

[bilbo85]

It worked! Thank you so much!