| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referenced cells | Excel Discussion (Misc queries) | |||
| can chart title be linked to variable cell address? | Excel Discussion (Misc queries) | |||
| Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
| Address for Linked Files in Formula | Excel Worksheet Functions | |||
| Missing linked file - can still be referenced but can't find it! | Excel Worksheet Functions | |||
![Emily[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
