writting formula on cell gives me a compile error: sintax error

[excells]

Hi,
I hope all is well.

Im doing my head in with the following expression:

Range("i" & varRowForBudgets).Formula = "=g "& varRowForBudgets&"/ g "& varRowForBudgets+10&""
Range("i" & varRowForBudgets).NumberFormat = "0.00%"

varRowForBudgets is currently 2000, replacing on the above:
I want VBA to write a formula in i2000
the formula i need written on cell i2000 is meant to be: =g2000/g2010
Im getting a compile error targeting "/" on the above expression.

Could anyone shed some light on this issue?

Regards,
Juan Arango

 

[Fazza]

maybe,

Range("i" & varRowForBudgets).Formula = "=g " & varRowForBudgets & "/g " & varRowForBudgets + 10

 

[=ODIN=]

dbl post

 

[excells]

Hi Fazza,
Thanks heaps for quick response.
I tried your suggestion but Im now getting

[h=1]Run-time error '1004' - Method 'Range' of object'_Global' failed[/h]

Do you know what might be happening?

ps. the variable was declared above in the code as follows
Dim varRowForBudgets As Integer


cheers

 

[excells]

Hi =ODIN=,
what do you mean by dbl post? did I accidentally posted twice?
cheers

 

[excells]

Hi Fazza,
I got it to work based on your suggestion.
in the end I used:

Range("i" & varRowForBudgets).Formula = "=g" & varRowForBudgets & "/g" & varRowForBudgets + 10 & " "

thanks a lot.

regards,
Juan