Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CDbl and "Type mismatch"
Neither of these cases work. I just get a "Type mismatch" error.
Dim deg(10), min(10), sec(10), DEGt(10) as Double deg(h) = CDbl(.Cells(2 + h, 3)) min(h) = CDbl(.Cells(2 + h, 4)) sec(h) = CDbl(.Cells(2 + h, 5)) DEGt(h) = deg(h) + min(h))/ 60 + sec(h) / 3600 or deg(h) = .Cells(2 + h, 3) min(h) = .Cells(2 + h, 4) sec(h) = .Cells(2 + h, 5)) DEGt(h) = CDbl(deg(h)) + CDbl(min(h)) / 60 + CDbl(sec(h)) / 3600 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Avoid Type Mismatch Error when using CDBL() | Excel Programming | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
Error Handling to mitigate "Run Time Erorr 13 Type Mismatch" | Excel Programming | |||
"FIND" generates "Type mismatch" error | Excel Programming |