ExcelBanter - offset and indirect function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - offset and indirect function (https://www.excelbanter.com/excel-worksheet-functions/17149-offset-indirect-function.html)

RICHARD ANNOR

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.

All times are GMT +1. The time now is 04:13 AM.