Overview VBA run-time error 91 is a common trappable error seen in VBA development. This error is triggered when you try to use an object variable (i.e. a variable which is of the “Object” type) that has no object (properly) assigned to it. This error
Introduction If you have a 64-bit version of Windows 7, Windows Server 2008 R2 or Windows Server 2012 running on your computer, you might have had an issue with the Windows core system file called “splwow64.exe”. What is it exactly? Is it harmful to your
This is one of the most common run-time errors. By the end of this article, you will understand why that is and how to fix it. A run-time error is the type of error that occurs during the execution of the code. VBA does not
Dealing with Objects/Class, Methods, Properties and events can be very confusing at times when you are still new in VBA programming or even programming in general. If you are not careful during your coding, you might generate errors like Run-time error ‘438’ — “Object doesn’t
There are three modes in which the VBA IDE can operate: Run mode, Break mode, or Design mode. The IDE is in design mode when you are writing code or designing a form. Run mode occurs when a procedure is running. Break mode is entered
What you’re seeing is a compile error that indicates that an Else (or ElseIf) keyword was not preceded by a correct If statement. Meaning, the compiler found an Else statement (which it will highlight for the user) without seeing an If statement in the lines
What is an apple? This potentially philosophical question is used in this article to introduce what causes the run-time error message “Object required (Error 424).” Consider the fruit Johnny Appleseed planted for homesteaders. The red, green, or yellow orb is an object. English speakers call
What’s worse than getting a runtime error in Excel VBA? A compile error. That’s because the actual error is not always highlighted, rather the opening Sub or Function statement. “Sub or Function not Defined” indicates a compile error. VBA displays this message when it cannot
When running a VBA procedure, you might receive this error message “Run-time error ‘9’, Subscript out of range”. In this article, we will talk about the possible reasons for the occurrence of this error and the ways to fix it. According to our recent review,
By Joseph Maabo New developers are usually faced with the “operation must use an updateable” query error when trying to update records in a database through a local or a web (online) application. Possible reasons for the occurrence of the error There are several reasons