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