Linker IT Software
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 2450 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:
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!]
Error Trapping with Visual Basic for Applications
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