Deleting rows in a named ranges does not modify formulas?
Posted: Tue Nov 05, 2013 7:04 pm
Hello Lars,
Sigh, sorry man, I stumbled on yet another formula problem, the DeleteRows (the correct one this time) does not adjust formula's.
After the sample code the original formula SUM(A1:A25) is SUM(A1:A35), same for the other vertical formula's, horizontal formula is also affected.
The named range is not reduced data=Sheet1!$A$1:$E$25 vs data=Sheet1!$A$1:$E35
You can reuse the sample i send to you, just replace the (only) line in the TfrmMain.btnCopyClick with this.
XLS[0].InsertRows(10, 5);
XLS[0].InsertRows(10, 5);
XLS[0].DeleteRows(10, 14);
XLS[0].DeleteRows(10, 14);
Sigh, sorry man, I stumbled on yet another formula problem, the DeleteRows (the correct one this time) does not adjust formula's.
After the sample code the original formula SUM(A1:A25) is SUM(A1:A35), same for the other vertical formula's, horizontal formula is also affected.
The named range is not reduced data=Sheet1!$A$1:$E$25 vs data=Sheet1!$A$1:$E35
You can reuse the sample i send to you, just replace the (only) line in the TfrmMain.btnCopyClick with this.
XLS[0].InsertRows(10, 5);
XLS[0].InsertRows(10, 5);
XLS[0].DeleteRows(10, 14);
XLS[0].DeleteRows(10, 14);