Excel 2003 can't assign digit to variable

sektor · July 23rd, 2010, 12:27 AM

I have a routine which do some calculations. I created it in Excel 2010 and it worked OK, but when I opened it in Excel 2003, then reading cell's value causes "Type mismatch" even when variable is Variant (before variant I used type Double and used conversion function CDbl).

Here's cell's value: 0,927381412344606
Here's variable: Dim vValue as Variant
Here's assigning: dValue = Cells(i, "I")

Is it bug or I did something wrong?

Shasur · July 23rd, 2010, 12:47 AM

Hi

Can you Try the following

Dim dValue as Double

dValue = Cells(i, "I")

Cheers
Shasur

sektor · July 23rd, 2010, 01:24 AM

Yes, I used also this "version", but resultless...

Shasur · July 23rd, 2010, 09:08 AM

Hi

Can you try the following:

Code:

Dim vValue As Variant
Dim dValue As Double
vValue = Cells(1, "A")
vValue = Replace(vValue, ",", ".")
dValue = CDbl(vValue)

If it doesn;t. Please post the code and the error you get

Cheers
Shasur