Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to show the formula of another cell
Hi
I want to show the content (formula) of another cell. For instance, if the formula in A1 is =2*12, I want cell B1 to show =2*12 instead of the answer (24). In other words i want the answer as usual (24) in A1, and in B1 I want the formula of A1 to be showed (=12*2). I am not interested in showing all of the formulas in the sheet, like you can do with tools/options/view/formulas. Please help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to show the formula of another cell
Hi
You can use this UDF: Public Function ShowFormula(MyCell As Range) ShowFormula = MyCell.Formula End Function Copy the function into workbook module. After that, you can use it in this workbook as any other formula. P.e. into B1 enter =ShowFormula(A1) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Bol" wrote in message ... Hi I want to show the content (formula) of another cell. For instance, if the formula in A1 is =2*12, I want cell B1 to show =2*12 instead of the answer (24). In other words i want the answer as usual (24) in A1, and in B1 I want the formula of A1 to be showed (=12*2). I am not interested in showing all of the formulas in the sheet, like you can do with tools/options/view/formulas. Please help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to show the formula of another cell
Thanks, that solved the problem. By the way, is it not possible to do this
without a UDF? Hi You can use this UDF: Public Function ShowFormula(MyCell As Range) ShowFormula = MyCell.Formula End Function Copy the function into workbook module. After that, you can use it in this workbook as any other formula. P.e. into B1 enter =ShowFormula(A1) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Some formula results will not show up in the cell | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |