VBA Run-time Error '91' Object-variable or With block variable not set

? Want to write real-world VBA code? - Check out my course: https://bit.ly/3XTnIm8 ? Looking for the source code for this video? - Download it here: https://shorturl.at/sYlSb - Subscribe to the channel here: https://bit.ly/36hpTCY Are you getting the frustrating VBA Run-time Error '91' when running your Excel VBA code? This error usually means you're trying to use an object variable that hasn’t been properly set. In this video, I’ll walk you through exactly what causes Error 91, how to understand what causes it so that you can easily fix it any time it occurs. * The meaning of Run-time Error '91' in VBA * Common causes and real-world examples * The two types of objects in VBA * How to avoid uninitialized object variables * Best practices to prevent similar errors in your code #VBAError91 #ExcelVBAError91 #Error91 #ObjectVariableNotSet #WithVariableNotSet Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9 or click in the left margin Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Autocomplete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8 or Ctrl + * To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y (note: this clears the clipboard)