Name/Description of error?
 

This VBA line...

MsgBox xlErrDiv0

....only gives me the number/value of the error!


How do I get the MsgBox to give me the name/description of the error?

Something like Error(xlErrDiv0).Name?

Name/Description of error?
 

msgbox err.description

Cliff Edwards

Name/Description of error?
 

Type "Cell Error Values" (with the quotes) into the VB editor's search field
and the first item listed in the results panel should say the say thing...
select that item and it gives you some code to use to get what I think you
are asking for.

--
Rick (MVP - Excel)


"Charlotte E." wrote in message
...
This VBA line...

MsgBox xlErrDiv0

...only gives me the number/value of the error!


How do I get the MsgBox to give me the name/description of the error?

Something like Error(xlErrDiv0).Name?