ExcelBanter - CVErr Usage

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - CVErr Usage (https://www.excelbanter.com/excel-programming/386844-cverr-usage.html)

clara

CVErr Usage

Hi all,

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

Clara

thank you so much for your help

Tom Ogilvy

CVErr Usage

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

All times are GMT +1. The time now is 10:25 AM.