Same result.
Your new formula still changes when cells are inserted (with shift cells
down)
Ok, then, Excel is holding the ref in the shift! Try it by doing the insert in
row 6 and copy the row 5 values down, then insert new values in row 5.
Alternatively, used sheet-level defined names for refs and see what happens.
Make the defined names column-absolute/row-relative as in my initial reply. Now
when you insert at row5 the formula in R5 will return 0!
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion