Code:
Dim sngFoo
    sngFoo = CSng(someVar)
Am I the only one who thinks that the above code should set sngFoo to 0. or Null and not return a Type Mismatch error if someVar is not numeric?

I guess I have to use this?

Code:
Dim sngFoo
    sngFoo = Null

If IsNumeric(someVar) Then sngFoo = CSng(someVar)