I have a little issue to define a formula. It may be very simple, but I don't know how to resolve it.
[VBA]
Cells(25, 7).Formula = "=CONCATENATE(C12," ",E12," ",D12,F12," Equity")"
[/VBA]
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?