Runtime error dblAddress = CDbl(CStr(varElement)) 
Author Message
 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
__________________________________



Mon, 28 Nov 2005 05:57:42 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Using CStr & CDbl -- problem

2. Trying to run mdb using A2K Runtime generates runtime error

3. Runtime error '429' at runtime

4. Runtime error '429' at runtime

5. Runtime error '429' at runtime

6. CDbl function in French IE4

7. CDbl does not work correctly

8. Cstr vs. Ctype

9. Difference between str and Cstr

10. When to use CInt() or CStr()

11. vbCrLF, chr(0), cstr, integer array declaration

12. format strings for CStr/ToText

 

 
Powered by phpBB® Forum Software