unwanted links come when new rows are inserted
For the record, the rows concerned were in an Excel 2003 List.
Copying the formulas down happens in Lists
I suggested either converting the List back to a Range or using a
Worksheet_Change macro to detect a row being added to the list (or the
first cell in a row being cleared) and having the macro clear the
formulas that were not desired.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|