Within string literals, double quotes mus be doubled:
sFormula="=IF(LEFT(RIGHT(A7,2),1)="","","".""&RIGH T(A7,1),"""""")"

HTH
--
AP
"Spike" a écrit dans le message de
...

I am trying to put the following formula into a piece of code (using the
variable 'sFormula' to hold the formula) and get the error message as
below,
any ideas how i can get around this. I know i could place it on the
worksheet somewhere and copy it but would like to keep it in code if
possible

sFormula="=IF(LEFT(RIGHT(A7,2),1)=",","."&RIGHT(A7 ,1),"")"

"Compile error expected end of statement"

it appears not to like the first comma in inverted commas

Any ideas will be gratefully received
--
with kind regards

Spike