jungix
07-21-2006, 09:51 AM
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?
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?