Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Displaying in a cell the formula from another cell
Hi,
is it possible to show (in text) the formula from the cell next to it? For example, in cell A1 I have the formula ='D:My Documents\[test.xls]Sheet1'!D18 which gives as result "18". Can I display in cell A2 the text "D:My Documents\[test.xls]Sheet1'!D18" somehow? Arjan |
#2
|
|||
|
|||
Arjan
How about a user defined function? Enter this and take the cell you wish to return the formula string from as the single parameter Function ShowFormula(rngInput As Range) As Variant Application.Volatile True ShowFormula = rngInput.Formula End Function -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Arjan" wrote in message ... Hi, is it possible to show (in text) the formula from the cell next to it? For example, in cell A1 I have the formula ='D:My Documents\[test.xls]Sheet1'!D18 which gives as result "18". Can I display in cell A2 the text "D:My Documents\[test.xls]Sheet1'!D18" somehow? Arjan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Conditional Formatting for dates | Excel Worksheet Functions |