apply the formula sign

[canvas]

Hi,

I´ve imported data from other application and some cells have some
formulas like 10*12 but without the = sign. How can I apply the = sign
to all the cells quickly without going one by one so that it
calculates the formula. Example, =10*12, should be 120.

Thanks!!

 

[Gord Dibben]

Copy this UDF to a general module in your workbook.

Function EvalCell(RefCell As String)
Application.Volatile
EvalCell = Evaluate(RefCell)
End Function

In an adjacent cell enter =EvalCell(cellref)


Gord Dibben MS Excel MVP

 

[Joe User]

Function EvalCell(RefCell As String)
Application.Volatile
EvalCell = Evaluate(RefCell)
End Function

Is there any reason to make the function Volatile if you pass RefCell and
use it in the function?

Volatile is evil: the referencing cell gets recalculated and the function
gets called every time any cell in the workbook is edited or filled in.

Why not rely on normal recalculation protocol to determine when to
recalculate the referencing cell?


----- original message -----

 

[Gord Dibben]

Good point Joe.

No idea what originally prompted the Application.Volatile


Gord

 

[canvas]

Thank you so much. That worked great!!