Entering Formulas

[Hannah]

Just wondering what the format is for entering formulas using vb....

I want to enter them into a row that i've just inserted, and i want them to sum all the values above until they reach another row that also holds totals, the cells in these rows will be in another colour...for arguements sake we'll say red.

Eg....

aaaa 1 2 3 4 5
aaaa 6 7 8 9 10
Totals for aaaa in red
bbbb 1 2 3 4 5
bbbb 6 7 8 9 10
bbbb 5 6 7 8 3
Totals for bbbb in red

etc etc

Any ideas????

 

[Juan Pablo González]

My approach would be to use Data | Subtotals. Then, if you need to, you can change the subtotals formatting to show them in red. You can record a macro while you do this to get the appropiate syntax.

 

[Hannah]

Thanks but it's not quite what I'm looking for...this has to be fully automated for the user. i'm mainly after the syntax for entering the formula in the active row, after that I'm probably alright.

Any other suggestions?

 

[Juan Pablo González]

Using Data | Subtotals, can also be fully automated, but, anyway... to insert a formula in the activecell you use

ActiveCell.Formula = "=SUM(A1:A3)"