Variable in text field

M

Michael

I have a spreadsheet where I place some information at the
top in a cell like 'See Row 16 for more detail'.
When I insert a row before row 16 it is now farther down
in the spreadsheet and I need to correct the text
information. Is there a way to reference the row such that
it will update the text to reference the correct row
automatically? Thanks. Michael
 
B

Bob Phillips

="See row " & ROW(A16) & " for more detail"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top