Updating counts and totals

[scottintexas]

I am adding rows above the "totals" row with VBA code. In the Totals row I have a count in Column 1 and a dollar total in Column 18. When I insert a row with values the count and the total do not automatically update. How do I tell the page to update?

[rylo]

Hi

1) Is your calculation on automatic or manual?
2) Does the new inserted row adjust the formula in the total row? Or is the formula not being impacted.


rylo

[scottintexas]

I don't know where to set a calculation to auto or manual. Almost everything is being done with vba except the totals are typed into the worksheet directly. The problem is that it starts out with

Please Login or Register  to view this content.

As soon as I add an entry I would either have to change the actual formula or expect excel to increase the row as I insert a new one.

The formula is not being impacted.

[rylo]

Hi

1) Calculation is found at tools, options, calculation, then nominate which calculation type you require.

2) However, I don't think that is your problem. Can you put up a sample file, including the code you mentioned, and step through your actions and what you would expect to result from those actions. I can't be sure if the item you posted is macro code that puts a fixed result into a cell, or morelikely is a FUNCTION in your workbook that needs to count a dynamic range to automatically update.


rylo