Hello Roshintosh & Paul,

Worksheet cells are all variants. When an error is found, Excel sets the cell to an Error type variant. This can be verified 2 ways. First by using IsError() and second by using VarType(). IsError will return True if the cell is an Error variant type and VarType returns 10 if the cell is an Error variant type.

To answer your question about getting a cell value, if there is an error Excel will only return the Error, not the value. So, your best bet is test for an error and handle it.

The help files tell you how to raise an error in cell, but not how to convert an Error type back to something useful like an Error Number. Here's how to do that...

Sub ErrorTest()

Dim Ret
Dim ErrNum

Ret = Range("A1").Value
If IsError(Ret) Then
E = CInt(Ret)
End If


End Sub

Hope this helps you some.

Sincerely,
Leith Ross