Solved: How to put "" in a Formula?

[jungix]

I have a little issue to define a formula. It may be very simple, but I don't know how to resolve it.


Cells(25, 7).Formula = "=CONCATENATE(C12," ",E12," ",D12,F12," Equity")"


The " after C12, is understood by the compilator as the end of the formula, and thus can't read the following. I could create a cell with a single space and concatenate it each time, but this would not be proper code and might slow down the macro. Is there a way to do it directly?

[lucas]

Try this if I understand you correctly:
=CONCATENATE(C12," ",E12," ",D12,F12," Equity")

[Norie]

Try this.


Cells(25, 7).Formula = "=CONCATENATE(C12,"" "",E12,"" "",D12,F12,"" Equity"")"

[jungix]

Your solution did not work lucas, you need some "" in the macro.

Thank you Norie, that works perdectly well!

[lucas]

Sorry, I misunderstood the question. Thanks Norie