Thread: delete row formula changes array range on related sheet
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default delete row formula changes array range on related sheet
Shane Devenshire wrote...
One way to handle this is to replace the reference A1:A1000 with
INDIRECT("A1:A1000")

Works buu is volatile.

or
OFFSET(A1,0,0,1000)
....

Delete row 1 and see what you get.
Reply With QuoteReply With Quote