CVErr Usage

's Computer Specifications

Hi all,

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

Clara

thank you so much for your help

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
technical trivia: CPU usage inverse of hard drive usage	John Doe	DIY PC	1	1st Nov 2007 04:47 AM
to save cpu usage & mem usage as graphs on excel?	=?Utf-8?B?c3BoaWxpcA==?=	Microsoft Windows 2000	1	16th Mar 2005 02:43 PM
Memory Usage and Page File Usage - Help!	RH	Microsoft C# .NET	4	26th May 2004 04:05 PM
HELP! intermittent random hang/release, low CPU usage but seeminglyhigh (?) mem usage	brosenau[	Windows XP Performance	6	3rd Dec 2003 03:37 PM
CVErr, Excel and VB .NET	Howard Kaikow	Microsoft Excel Programming	2	1st Oct 2003 05:06 PM