View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
brownti via OfficeKB.com brownti via OfficeKB.com is offline
external usenet poster
 
Posts: 103
Default Delete rows and refs

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200705/1