[princeb]

vba is fine but it seems to exist halfway outside the calculation chain space that sheets and cells operate in. excel can work with it, but one has to be quite careful with function returns and parameters.

offsets and indirects also exist in that twilight zone being volatile functions.

these three combined can bring down a reasonably sized spreadsheet.