Problem with Formula in a cell

[IanPikeBioquell]

Can anybody please help, I have a script that reads data in from an SQL database. At the end of a row of data I want to enter a formula that sums that row. (the row will not always have the same number of columns in it)

I genearate the formular as follows

formular = "=sum(RC[-" & Count - 1 & "]:RC[-1])"

this returns

=sum(RC[-19]:RC[-1]) (for example)

but when I use to populate the cell

.Cells(22, Count + 1).FormulaR1C1 = formular

the cells value becomes

=SUM(R[-1]C[217]:R[-1]C[235])


Hope this is clear and that someone can help. I am using Excel 2003 on a Vista PC.

 

[IanPikeBioquell]

Thanks for all this guy's, sorry i have been away from my desk for a while in meetings!

Let me try and digest what you have said and give it try. Will probably not be untill tomorrow now.

Again thanks for all you help and suggestions.