Hello,
I have just joined what looks like an excellent forum so well done.
I have a simple problem but cannot think of a workaround to solve the problem. I am writing data to a spreadsheet to produce a report with sub-totals and a grandtotal at the bottom. At the subtotal level, I write the sum function into the cells summing all the rows up above which all works ok. Where I am having the problem is a the grand total line with writes the sum formula into the cell '=Sum(E5,E11,E15 etc) in RC notation of each of the sub-total lines. The formula is built up as your iterate through the loop writing results to the sheet. However I have now realised I have gone over the 30 arguments in the sum formula and it does not like it. I do not want to keep a running total and write the total sum at the grand total line but to write a formula summing up all of the sub-totals.
Any ideas?
thank you
Simon
Bookmarks