Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a cell's formula in a different cell
Is it possible to have any given cell return another cell's formula? I have
a column in a certain spreadsheet that I use for debugging purposes where I copy the formula from a cell in the same row and paste it into the cell in that column with an apostrophe at the beginning so that I can actually see the formula. Trouble is, if I ever add a row above, the formula that I copied and pasted is now incorrect. I want to be able to format the cells in my 'debugging' column so that they will return the formula of the target cell without actually performing the formula. I hope that wasn't too confusing... :) Thanks in advance for any help. -- "I''m just a simple man trying to make my way in the universe..." |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a cell's formula in a different cell
That did it. Thank you very much!
-- "I''m just a simple man trying to make my way in the universe..." "Gary L Brown" wrote: My best suggestion is to but the following User-Defined-Function in your Personal.xls. '/==================================/ Public Function FormulaView(Select_Cell As Range) As String FormulaView = Select_Cell.Formula End Function '/==================================/ Then you can use the function as... =FormulaView(C5) and the cell will show the formula that is in C5. HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "T.R. Young" wrote: Is it possible to have any given cell return another cell's formula? I have a column in a certain spreadsheet that I use for debugging purposes where I copy the formula from a cell in the same row and paste it into the cell in that column with an apostrophe at the beginning so that I can actually see the formula. Trouble is, if I ever add a row above, the formula that I copied and pasted is now incorrect. I want to be able to format the cells in my 'debugging' column so that they will return the formula of the target cell without actually performing the formula. I hope that wasn't too confusing... :) Thanks in advance for any help. -- "I''m just a simple man trying to make my way in the universe..." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Formula to transfer text from merged cells to single cell? | Excel Discussion (Misc queries) | |||
Returning the formula in a cell | Excel Discussion (Misc queries) | |||
to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |