
Runtime error dblAddress = CDbl(CStr(varElement))
In VBA:
Dim dblAddress As Double
Dim varElement As Variant
'End of code
if CStr(varElement) = "aaaaaaaaaaaaaaaa"
all is well.
if CStr(varElement) = "aaaaaaaaaaaaaaaaaaa"
CDbl(CStr("aaaaaaaaaaaaaaaaaa")) poops with a Runtime error that I cannot catch with On Error GoTo MissAll.
I even tried
CDbl(Mid(CStr(varElement), 1, 16)) No dice still the same problem.
Why?
--
George Hester
__________________________________