Ok if I am understanding this right you want D to show the
value of A correct. If this is so then change 'D = Evaluate
(A)' to 'D = A'. Also since A is a string you might have
to setup 'A = "1+5+9+7"' like this 'A = Integer
("1+5+9+7")' to get it to do the math. If I am incorrect
in this then a little more explanation of what your
attempting would help. What are you trying to do with this
information? Is this being displayed via a cell, or
through the msgBox?
Ascheman

-----Original Message-----
Sure thing

Sub test()
Dim A As String, D As Double
A = "1+5+9+7"
D = Evaluate(A)
MsgBox D, , A
End Sub

HTH. Best wishes Harald

"Andoni " skrev i
melding
...
If I have a string such as:

a="1+5+9+7"

and I want to use the number, non the string, I mean if
I want to get
the answer=22

a=cdbl(A) does not work!
How can I do this?

PS: I need this!


---
Message posted from http://www.ExcelForum.com/



.