Hi, this is driving me nuts...
In VBA I need to add up values from a Range: oRng with:
Dim SumValue as Double, ExtractedValue as Double
Dim oCell as Range, oRng as Range
SumValue = 0
For each oCell in oRng
SumValue = SumValue + ExtractedValue
Next
oRng has a series of cells with string values like: "notimportant € 8,50", or "notimportant € 637,00"
I need to add up the amounts at the right of each value. There is a space between the € and the amount, so I need to add up everything right from the space, but there is a " , " in the string value as a decimal (European number style).
My question: How can I retrieve the ExtractedValue from these strings?
Thx.
Bookmarks