Cells containing error values

A cell may contain an error value. For example, if the cell have error value #N/A, the VBA will error out with “Error 2042”.

From the immediate window:
? cvErr(xlErrNA)
Error 2042

Error 2042 is the equivalent of #N/A

also you can query the constant:

? xlErrNa
2042

http://www.pcreview.co.uk/forums/thread-965618.php

http://www.techonthenet.com/excel/formulas/iserror.php

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s