Ensure the object hasn't been set to Nothing or destroyed before you try to access it.

To fix , you must ensure that every object variable is properly assigned using the Set keyword before your code attempts to use its properties or methods. Quickest Fixes

In Visual Basic, standard variables (like numbers or text) use simple = signs, but (like Worksheets, Ranges, or Documents) require the Set keyword. Wrong: myRange = Range("A1") Right: Set myRange = Range("A1") 3. Check for Successful Finds VBA: Run time error '91'? - Stack Overflow

Make sure you enter a With block through the With statement rather than jumping into it with a GoTo command.