Microsoft Office Forums - View Single Post - [Solved] I use an array to traverse the monthly worksheet summaries in the workbook, why the display types do

leeqiang · 10-07-2020, 01:42 AM

Quote:

Originally Posted by Guessed

I'm not seeing a type mismatch on my machine so it probably depends on the contents of your worksheets.

Why aren't you using the previously supplied solution of using formulas on the bottom of your tables? See https://www.msofficeforums.com/excel...-each-row.html

Because the data area of the table is dynamic, the data rows increase at any time. The purpose of writing a program is to automatically summarize the data in the corresponding column to the next row of the data area as the data changes. I don’t know how to rewrite the code in this case for the summation of the previous question?