A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0-9 !@$* active | api | Application | array | chart | clipboard | color | date and time | debug | Error | file | filter | find | format | log | loop | named range | PPT | Pivot Table | record | udf | workbook | wrapper Continue at Database_code 948 Steps to 6 Figures by Learning Excel-VBA and Other Skills |
| • | 31 Common Excel Errors and How to Solve Them | |
| • | 12 Errors People Make in Excel | |
| • | On Error Resume next | |
| • | err | |
| • | Error 5 | |
| • | Using stop instead of error handling | |
| • | Err <> 0 | |
| • | Syntax errors | |
| • | =iferror | |
| • | Misspelling error | |
| • | mixing up row and column error | |
| • | On Error Goto ErrHandler | |
| • | Resume Next or Label - Error Handling | |
| • | Error(x) ' displays error message | |
| • | elseif err = 75 then ' directory already exists? | |
| • | errors - If it's broken you made a mistake (attitude) | |
| • | ShowSheet - udf - wraps the code to prevent errors | |
| • | Error - Type Mismatch | |
| • | Error 2042 - | |
| • | IsError( ) - vba function | |
| • | Upper/Lower Case Common Error | |
| • | Error File in use | |
| • | Error handling Logic - column doesn't exist | |
| • | err <> 1004 and Error <> 40040 | |
| • | LogSQLError - | |
| • | Errors from hardcoding | |
| • | Colors in vb Editor - Green - comment - blue Excel statement ; red = syntax error | |
| • | Err.Raise | |
| • | =IfERROR(VLOOKUP(INDIRECT(ADDRESS(ROW(),VLOOKUP($BW2,'Field To Use'!$H:$O,6,0))),'Rating Lookup'!$A:$B,2,0),0) | |
| • | Err = 53 ' file not found | |
| • | Application.ErrorCheckingOptions.BackgroundChecking = False ' recorded optimize | |
| • | Error 2015 | |
| • | WhatDB() - udf - queries the gADO.Properties(9) and if an error occurs returns "Not Connected" | |
| • | override date | |
| • | Err.Number | |
| • | Err.Description | |
| • | Err.Clear | |
| • | byRef argument type mismatch - syntax error | |
| • | #NAME error | |
| • | #REF error | |
| • | ErrHandling.bas | |
| • | if Error = "[Microsoft] [ODBC Driver Manager] Data source..." Then after set gADO and ask to install driver | |
| • | Processing Multiple Errors | |
| • | Formula error =A1-B1/2 | |
| • | Formula Error =C3-C2 and C2 is blank (if needed) | |
| • | #VALUE! | |
| • | Error 2015 | |
| • | Create syntax error to save a location you want to go back to | |
| • | Subscript out of range | |
| • | copy modules in and finding all the syntax error | |
| • | Windows(sWBK).Activate - Error 9 subscript error when New Window used and have :1 and :2 windows | |
| • | #SPILL! | |
| • | Missing Error Handling problem | |
| • | Standard error handling | |
| • | Missing error handling and premature exits | |
| • | RemoveRangeNames - Removes ones with errors |