logo rip
RIP Tutorial
  • Tags
  • Topics
  • Examples
  • eBooks
Download VBA (PDF)

VBA

  • Getting started with VBA
  • Awesome Book
  • Awesome Community
  • Awesome Course
  • Awesome Tutorial
  • Awesome YouTube
  • API Calls
  • Arrays
  • Assigning strings with repeated characters
  • Attributes
  • Automation or Using other applications Libraries
  • Collections
  • Comments
  • Concatenating strings
  • Conditional Compilation
  • Converting other types to strings
  • Copying, returning and passing arrays
  • CreateObject vs. GetObject
  • Creating a Custom Class
  • Creating a procedure
  • Data Structures
  • Data Types and Limits
  • Date Time Manipulation
  • Declaring and assigning strings
  • Declaring Variables
  • Error Handling
  • Events
  • Flow control structures
  • Frequently used string manipulation
  • Interfaces
  • Macro security and signing of VBA-projects/-modules
  • Measuring the length of strings
  • Naming Conventions
  • Non-Latin Characters
  • Object-Oriented VBA
  • Operators
  • Passing Arguments ByRef or ByVal
  • Procedure Calls
  • Reading 2GB+ files in binary in VBA and File Hashes
  • Recursion
  • Scripting.Dictionary object
  • Scripting.FileSystemObject
  • Searching within strings for the presence of substrings
  • Sorting
  • String Literals - Escaping, non-printable characters and line-continuations
  • Substrings
  • User Forms
  • VBA Option Keyword
  • VBA Run-Time Errors
    • Run-time error '13': Type mismatch
    • Run-time error '20': Resume without error
    • Run-time error '3': Return without GoSub
    • Run-time error '6': Overflow
    • Run-time error '9': Subscript out of range
    • Run-time error '91': Object variable or With block variable not set
  • Working with ADO
  • Working With Files and Directories Without Using FileSystemObject


VBA

  • Getting started with VBA
  • Awesome Book
  • Awesome Community
  • Awesome Course
  • Awesome Tutorial
  • Awesome YouTube
  • API Calls
  • Arrays
  • Assigning strings with repeated characters
  • Attributes
  • Automation or Using other applications Libraries
  • Collections
  • Comments
  • Concatenating strings
  • Conditional Compilation
  • Converting other types to strings
  • Copying, returning and passing arrays
  • CreateObject vs. GetObject
  • Creating a Custom Class
  • Creating a procedure
  • Data Structures
  • Data Types and Limits
  • Date Time Manipulation
  • Declaring and assigning strings
  • Declaring Variables
  • Error Handling
  • Events
  • Flow control structures
  • Frequently used string manipulation
  • Interfaces
  • Macro security and signing of VBA-projects/-modules
  • Measuring the length of strings
  • Naming Conventions
  • Non-Latin Characters
  • Object-Oriented VBA
  • Operators
  • Passing Arguments ByRef or ByVal
  • Procedure Calls
  • Reading 2GB+ files in binary in VBA and File Hashes
  • Recursion
  • Scripting.Dictionary object
  • Scripting.FileSystemObject
  • Searching within strings for the presence of substrings
  • Sorting
  • String Literals - Escaping, non-printable characters and line-continuations
  • Substrings
  • User Forms
  • VBA Option Keyword
  • VBA Run-Time Errors
    • Run-time error '13': Type mismatch
    • Run-time error '20': Resume without error
    • Run-time error '3': Return without GoSub
    • Run-time error '6': Overflow
    • Run-time error '9': Subscript out of range
    • Run-time error '91': Object variable or With block variable not set
  • Working with ADO
  • Working With Files and Directories Without Using FileSystemObject

VBA VBA Run-Time Errors


Introduction

Code that compiles can still run into errors, at run-time. This topic lists the most common ones, their causes, and how to avoid them.

VBA Run-Time Errors Related Examples

  • Run-time error '13': Type mismatch
  • Run-time error '20': Resume without error
  • Run-time error '3': Return without GoSub
  • Run-time error '6': Overflow
  • Run-time error '9': Subscript out of range
  • Run-time error '91': Object variable or With block variable not set
pdf PDF - Download VBA for free


Previous Next






This modified text is an extract of the original Stack Overflow Documentation created by following contributors and released under CC BY-SA 3.0
This website is not affiliated with Stack Overflow

logo rip
SUPPORT & PARTNERS
  • Advertise with us
  • Contact us
  • Privacy Policy
STAY CONNECTED

Get monthly updates about new articles, cheatsheets, and tricks.