VBA parse extracted number in text to double?

Posted 12 October 2010 - 10:12 AM

I have a macro that extracts a number from a cell in Excel, as text, using VBA, and I keep getting an error for type mismatch when dealing with MSRP and Price. I extract a string from a large cell containing a description formatted for web, and for this particular case, it's a dollar amount, i.e. "$1.01" in text form. I need to multiply it and paste into another column, which it'll do but it'll give me an error due to type mismatch. what should i do?

(the i in the cells reference is from a "For i = 2 to End of Sheet" loop)