B
brownti via OfficeKB.com
I am wondering if there is a macro that can be written that will delete a row
and also any reference to any cells in that row from froumulas on the sheet.
For example: A1=B1+B2+B3 i then delete row 2 and get A1=B1+#REF+B3, i would
like to get A1=B1+B3. Is something like this possible? Maybe when running
the delete row macro it would do a find and replace? Any thoughts? Thanks
and also any reference to any cells in that row from froumulas on the sheet.
For example: A1=B1+B2+B3 i then delete row 2 and get A1=B1+#REF+B3, i would
like to get A1=B1+B3. Is something like this possible? Maybe when running
the delete row macro it would do a find and replace? Any thoughts? Thanks