Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Trappable Excel errors (Read 2505 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Trappable Excel errors
13.12.09 at 11:01:11
 
Trappable Excel errors
 
These are the trappable errors in Excel. To create an error code make a variable of type variant and assign the error by converting the number value to an error type using the CVErr function:
 
Example:
Dim vnt as Variant
vnt = CVErr(xlErrDiv0)
 
Error code Value Error              
xlErrDiv0 2007 [#DIV/0!]      
xlErrNA       2042 [#N/A]              
xlErrName 2029 [#NAME?]        
xlErrNull      2000 [#NULL!]              
xlErrNum 2036 [#NUM!]              
xlErrRef       2023 [#REF!]            
xlErrValue 2015 [#VALUE!]
 
 
 
Source:
Error Trapping with Visual Basic for Applications
http://support.microsoft.com/kb/146864
Back to top
 
« Last Edit: 13.12.09 at 11:09:10 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1