Keep cell reference when insert row

Alex · Jun 1, 2004

How do I write a formula =B8-B12 to always subtract B8
from B12 even after I insert a row. When I insert a row,
formula changes to =B8-B13.

Thanks.

Alex · Jun 1, 2004

I used Indirect("A!10") to get it to work.

Alex