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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formual to get reference contents
One way is to select Tools -- Options, and on the View tab, check Formulas.
Your spreadsheet will now show formulas, not results. Print it and then deselect formulas on the View Tab. HTH Sincerely, Michael Colvin "John M" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formual to get reference contents
Michael,
I want to get it from a formula and not just to view them. Thanks anyway. "Michael" wrote: One way is to select Tools -- Options, and on the View tab, check Formulas. Your spreadsheet will now show formulas, not results. Print it and then deselect formulas on the View Tab. HTH Sincerely, Michael Colvin "John M" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formual to get reference contents
Hi John
I've seen a similar request not too long ago. Someone had an answer using a UDF. A search might come up with something. Regards! Jean-Guy "John M" wrote: Michael, I want to get it from a formula and not just to view them. Thanks anyway. "Michael" wrote: One way is to select Tools -- Options, and on the View tab, check Formulas. Your spreadsheet will now show formulas, not results. Print it and then deselect formulas on the View Tab. HTH Sincerely, Michael Colvin "John M" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formual to get reference contents
On Mon, 5 Feb 2007 12:31:00 -0800, John M
wrote: 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 You will need a UDF in VB. <alt-F11 opens the VB Editor Ensure your project is highlighted in the Project Explorer window, then Insert/Module and paste the code below into the window that opens. To use this UDF, enter the formula =ShowFormula(cell_ref) into some cell. It will display the actual contents of cell_ref ============================================= Function ShowFormula(rg As Range) As String ShowFormula = rg.Formula End Function ============================================= --ron |
Reply |
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 |