Thread: I want to prevent a formula from being affected by insert line
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd Bernd is offline
external usenet poster
  
Posts: 92
Default I want to prevent a formula from being affected by insert line
=AVERAGE(INDIRECT("A1:A10"))

Regards,
Bernd

Reply With QuoteReply With Quote