Display formula in VBA

[Anax]

I have the following problem using VBA.
I need to check if a cell contains formula and if it does to display the formula (as text) into another cell
I found the way to check if there is formula, but I cannot display it. When i try to use .formula it just displays the numerical result of the calculation but not the formula itself.
Any suggestions?

Thank you in advance

 

[acw]

Hi

Here's a couple of ways

1) convert the output cell to text format (outputcell.numberformat = "@" then put in the formula

2) the outputcell has "'" & activecell.formula


HTH

Tony

 

[Anax]

This works fine!
Thank you!