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.