CVErr Usage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

Why we use the CVErr. We can use the cell error value directly.

Clara


thank you so much for your help
 
If cell.Value = cvErr(xlErrNA) then


demo'd from the immediate window:

? activecell.Value
Error 2042
? activecell.Value = cvErr(xlErrNA)
True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlinks to =Hyperlinks formula - Challenging 7
absolute maximum with sign 1
Problem with UDF 4
Find errors in Excel. 7
Returning custom errors from UDFs 8
UDF Drawing Shape Not Re-Positioning 2
trap overflow of an division in vba 4
error code help 2

Back
Top