Cell reference OR INDIRECT function

E

Excel ESG

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
 
V

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
Click to expand...

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
 
Top