show formulas in Excel Vba

[ganeshr]

Hello there. would you please Suggest me the code in VBA to show the formulas in different cells.

[Trebor76]

Hi ganeshr,

This will put the active cells' formula into a message box if there's a formula in the active cell:


If ActiveCell.HasFormula = True Then
MsgBox ActiveCell.Formula
End If

HTH

Robert

[ganeshr]

Thanks a lot. It works.

[Trebor76]

Thanks for letting us know and you're welcome :)

[ganeshr]

Thank you. One more request please.

[ganeshr]

In Excel if i change the input value of one variable or an attribute by certain percentage, What will be the effect of the same on end variable?

[Bob Phillips]

In Excel if i change the input value of one variable or an attribute by certain percentage, What will be the effect of the same on end variable?

Try it and see.