Thread: When I add a row to excel how can I stop formulae changing
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave L
 
Posts: n/a
Default When I add a row to excel how can I stop formulae changing


"vezerid" wrote:

=SUM(INDIRECT("A1:A5"))

HTH
Kostis Vezerides

Thanks for that.
How about if I after inserting a row A1:A5 changes to A1:A6

TIA
Dave
Reply With QuoteReply With Quote