Eval function help

[davei]

Hello

I am using the following VBA script to show formulae in calculations:

Public Function Eval(S As String)
    Eval = Evaluate(S)
End Function

No matter what I do (e.g. include application.volatile) I always get the #NAME? error after I change any other formula in the sheet and thus have to manually recalculate each time which is annoying.

The only thing worth noting is I have lots of named cells e.g. a formula in cell B6 might be
s_es*A_t*E_c
and then the cell adjacent uses eval(B6)

the definitions of the name s_es is also using the eval function, so wondering if eval(x) of an eval is causing the issue?

Essentially I'm trying to use Excel as a calc pad that displays the workings when printed, so if there is a completely different way of doing this then that would also be very helpful!

Thanks in advance

 

[davei]

should have also said using windows 7 64 bit and excel 2007. Not sure if that is relevant.

Cheers

 

[GlennUK]

When you say "definitions of the name s_es is also using the eval function" ... that almost sounds like it isn't referring to an actual cell. Is it a cell? Or is it a calculation within a defined name?

 

[davei]

so say cell b6 is called "s_es". the formula within that cell is eval(a6) and then cell a6 is another string of a formula but without the "=" at the front

the defined name doens't have a calculation within it. it is literally just a named cell.

 

[Aladin Akyurek]

Hello

I am using the following VBA script to show formulae in calculations:

Public Function Eval(S As String)
    Eval = Evaluate(S)
End Function

No matter what I do (e.g. include application.volatile) I always get the #NAME? error after I change any other formula in the sheet and thus have to manually recalculate each time which is annoying.

The only thing worth noting is I have lots of named cells e.g. a formula in cell B6 might be
s_es*A_t*E_c
and then the cell adjacent uses eval(B6)

the definitions of the name s_es is also using the eval function, so wondering if eval(x) of an eval is causing the issue?

Essentially I'm trying to use Excel as a calc pad that displays the workings when printed, so if there is a completely different way of doing this then that would also be very helpful!

Thanks in advance

See post #2 for an alternative code for EVAL in...

http://www.mrexcel.com/forum/showthread.php?t=553863

 

[davei]

sweet as. solved. Thanks!