Load a Dynamic formula using vba

[RobP]

Hi all,

I have a list of peoples names in column C, and some numbers alongside in columns D, F and H. (cols E, G and I contain text data).

The list of names is generated elsewhere, and varies in size (sometimes it could be 5 names in the list, other times it could have 20 names in the list etc.)

In column G, I want to insert a "TOTAL" formula, to sum cols D, F and H, using VBA - as I cant preload the formula, not knowing the size of list beforehand. (Sure I could load the complete column before with formula, but thats a little lame if I only have 5 entries.)

Any ideas on the syntax to be used for inserting a dynamic formula into a cell ?

x = row number

Range("G" & x).Formula =

Thanks
Rob

 

[VoG]

Try

Range("G" & x).Formula = "=SUM(D" & x & ",F" & x & ",H" & x & ")"

 

[RobP]

Many thanks .... that works perfectly ... I couldn't suss out where my "" were supposed to be.