My guess, maybe: =INDIRECT("B450")
which will always point to & return the contents of B450
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100, Files:360, Subscribers:56
xdemechanik
---
"Erich Koch" wrote in message
...
This should be very easy, BUT can't figure it out.
Excel 2003.
I have a single sheet with 7 columns and around 550 rows.
I made an Index on the top area of the spread sheet with the idea of
linking areas bellow.
I know how to link to something like B450, BUT what I want to link is the
CONTENT on that cell,
so if I insert or delete a row above B450 the link stay intact.
Thanks,
Erich