Cell reference OR INDIRECT function

[Guest]

If I use cell references the correct link to the data in cell in lost when
rows are inserted.

Therefore I use the INDIRECT(column()&row()) format,

Is there another way, because my formula's are incresing dramaticaly

 

[vezerid]

If I use cell references the correct link to the data in cell in lost when
rows are inserted.

Therefore I use the INDIRECT(column()&row()) format,

Is there another way, because my formula's are incresing dramaticaly

There is no other way to *always* refer to A1 regardless of
insertions, deletions or moving of cells except:
=INDIRECT("A1")
=INDIRECT(ADDRESS(1,1))

Are your formulas increasing in size or population?

HTH
Kostis Vezerides

 

[Guest]

I was already afraid for that answer,

Although thanks for your responce