If cell.Value = cvErr(xlErrNA) then


demo'd from the immediate window:

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


--
Regards,
Tom Ogilvy




"clara" wrote:

Hi all,

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

Clara


thank you so much for your help