Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formual to get reference contents
Hi,
How can i get the reference contents from a cell? This may be explained with an example. Cell contains "Sheet1!A5" which equates to 20 say. If i use cell function i can only get 20. How can i extract the "Sheet1!A5" information. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Using a cells contents to reference a sheet. | Excel Worksheet Functions | |||
Using cell contents to reference worksheet names | Excel Discussion (Misc queries) | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions |