Name/Description of error?

C

Charlotte E.

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?
 
R

Rick Rothstein

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.
 
Top