Thread: When I add a row to excel how can I stop formulae changing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default When I add a row to excel how can I stop formulae changing
=SUM(INDIRECT("A1:A5"))

HTH
Kostis Vezerides

Reply With QuoteReply With Quote