View Single Post
  #1   Report Post  
RICHARD ANNOR
 
Posts: n/a
Default offset and indirect function

I would like to know the difference between OFFSET and INDIRECT worksheet
functions in preventing formulas from being disrupted in situations where
cell are deleted and/or inserted. Which of the 2 is the best method to use.
Thank you.