MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Joe on January 23, 2002 10:44 AM

I have an excel spreadsheet that logs 1000 entries, I want to add new rows and keep calculating. I try inserting new rows and they appear but then when I put values in they do not calculate. I could e-mail the excel attachment to someone if they want to help. Thanks

Posted by Joe Was on January 23, 2002 10:57 AM

Inserting rows is not enough, if you are calculating in the row you need to also copy any formulas to the new row.

You have two options, you can put the formulas in a area of the sheet that you are not using and copy that row to the new inserted row, by code or not. Or, you can code the formulas into your insert code. JSW