Ensure the object hasn't been set to Nothing or destroyed before you try to access it.
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 How to Fix Runtime Error 91 in a Safe and Easy Way
Make sure you enter a With block through the With statement rather than jumping into it with a GoTo command. Ensure the object hasn't been set to Nothing