B
Brandon C
Hi all-
I've got an Eval function defined as:
Function Eval(scell As String)
Application.Volatile
Eval = Application.Evaluate(scell)
End Function
I can't get Eval to evaluate the String as a formula as desired. Here's a mocked up example:
H4: LOWER(K&ROW())
H5: SQRT(K&ROW())
K15: AbcD
K16: 49
L15: =Eval(H4)
L16: =Eval(H5)
I would expect the value in L15 to be "abcd" and L16 to be 7. Instead, I get the infamous #NAME? in my face. What gives?
-brandon
I've got an Eval function defined as:
Function Eval(scell As String)
Application.Volatile
Eval = Application.Evaluate(scell)
End Function
I can't get Eval to evaluate the String as a formula as desired. Here's a mocked up example:
H4: LOWER(K&ROW())
H5: SQRT(K&ROW())
K15: AbcD
K16: 49
L15: =Eval(H4)
L16: =Eval(H5)
I would expect the value in L15 to be "abcd" and L16 to be 7. Instead, I get the infamous #NAME? in my face. What gives?
-brandon