Search : in
By :

Excel Formula Display in Cell

Last answer on Apr 9, 2009 2:55:36 am BST eltonlaw, on Apr 8, 2009 6:42:25 am BST 
 Report this message to moderators

Hello,
Apologize if the question is too stupid.
In cell A4, it contains a formula =Sum(A1:B3)+A3/B2.
How to display the formula in cell A6 for this formula please ?
That is =Sum(A1:B3)+A3/B2
I know Control + ~ can view the formula in a spreadsheet.
But that is view only. Another control + ~ will turn back to normal.
I want to display the formula in cell.
Thanks

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Excel Formula Display in Cell » in :
Excel formula to get the cell with the text Show
Firmnual Help If cell is blank go to next ce Show
Basic Excel Formulas Show Basic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL �+ ;� in the chosen cell. To insert current time, press CTRL�+...
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
[VBA] A function that returns the color of an active MFC Show[VBA] A function that returns the color of an active MFC This function returns the value of the active format in conditional formatting. With the function below, two values can be returned. Mode = 0: the value of Interior.ColorIndex...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

eltonlaw, on Apr 8, 2009 9:18:46 am BST
  • +1

Hello,

Add more .........

Apologize if the question is too stupid.
In cell A4, it contains a formula =Sum(A1:B3)+A3/B2.
How to extract this formula in cell A6 as a string of text please ?
That is ... I want cell A6 to display =Sum(A1:B3)+A3/B2
I know Control + ~ can view this formula in a spreadsheet.
But that is view only. Another control + ~ will turn back to normal.
Also, put ' at the front and paste the formula can help one cell ... but this is not applicable in VBA (marco writing).
VBA will capture the script as below
ActiveCell.FormulaR1C1 = "'=SUM(A1:B3)+A3/B2"
Next time the formula in cell 6 may be =A3-B2+A1 (not =SUM(A1:B3)+A3/B2)
Use Marcos to run will become overwrite the new formula to =SUM(A1:B3)+A3/B2 instead of =A3-B2+A1
Someone asked me to use Word as interface and then copy/paste as value.
But I want to use the functions within Excel or use Marcos to accomplish changing cell formula to text.

Can any expert show me how to solve please ?
Thanks

   
Reply to eltonlaw

2

aquarelle, on Apr 8, 2009 2:27:32 pm BST
  • +3

Hi,

Try with this macro : 

Sub DysplayFormula()
    Range("A6").Value = "'" & Range("A4").Formula & ""
End Sub


Hope this will work as you want.

Best regards "Pour trouver une solution � ses probl�mes, il faut s'en donner la peine."

   
Reply to aquarelle

3

 eltonlaw, on Apr 9, 2009 2:55:36 am BST

Thanks.
It worked !!!

   
Reply to eltonlaw
Ask your question Reply
They need your help