Thread: using the address referenced in a linked cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emily[_2_] Emily[_2_] is offline
external usenet poster
  
Posts: 13
Default using the address referenced in a linked cells
I have a spreadsheet that has many cells linked to other cells on the same
sheet
From the links I want to know the row number of the reference.
Eg:
A1 value CAT
A200 value CAT

Cell A1 has the formula "=A200"

Using Cell A1 information only I want to know row the row number it
references , that is 200. How do i do this?


Reply With QuoteReply With Quote