Thread: Can array formulas work if rows are inserted?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris
 
Posts: n/a
Default Can array formulas work if rows are inserted?
I have a worksheet containing 2 array formulas. If I insert rows within the
cell reference range the formulas appear to automatically update to reflect
the new rows BUT the formula no longer returns a result just #NA.
Is there a way to prevent this and allow row insertions?
Reply With QuoteReply With Quote