Type mismatch !

Cheers Norman,

Declaring the variable as variant makes no difference unfortunately.

If the value in the cell is #N/A, then the statement

dim var1 as variant
var1 = Cells(1, 1).Value

gives a type mismatch. (run time error 13)

I'm totally confused !

Hi Roshintosh,

> Declaring the variable as variant makes no difference unfortunately.

If the variable is declared as a string, the macro will break with a
run-time 13 type mismatch code.

I tried:

Sub ABC()
Dim var1 As Variant
var1 = Cells(1, 1).Value
Debug.Print "var1", var1
Debug.Print "#N/A error number", CVErr(xlErrNA)
End
End Sub

This produced the following in the imediate window:

var1 Error 2042
#N/A error number Error 2042

Thus, the variant variable correctly holds the cell's error value.

---
Regards,
Norman



"Roshintosh" <roshintosh@yahoo.co.uk> wrote in message
news:1131622578.522911.321030@g43g2000cwa.googlegroups.com...
> Cheers Norman,
>
> Declaring the variable as variant makes no difference unfortunately.
>
> If the value in the cell is #N/A, then the statement
>
> dim var1 as variant
> var1 = Cells(1, 1).Value
>
> gives a type mismatch. (run time error 13)
>
> I'm totally confused !
>