No, you can put a reference within indirect and it always will point to that
particular cell

=INDIRECT("A2")

as opposed to =A2

Don't know if that's your problem though

Regards,

Peo Sjoblom

"stbookkeeper" wrote:

Is there a way to format a cell so that the formula connected to that cell
automatically adjusts to a line insertion?