How To Fix Runtime Error 91 In A Safe And Easy Way Site

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

Add a Set statement to link your variable to a real object (e.g., Set mySheet = Sheets("Sheet1") ). How to Fix Runtime Error 91 in a Safe and Easy Way

Ensure the object hasn't been set to Nothing or destroyed before you try to access it. Make sure you enter a With block through