Runtime Error 91: Object variable or With block variable not set

**Andrew.Trevayne** · 06-21-2018, 08:31 AM

Hi all,
I have a macro that performs filtering and deleting unwanted rows.
I find it strange that it is now not working when it was working few days ago.
It's giving me a runtime error 91.

Here's my code:

Please Login or Register  to view this content.

Any ideas? Appreciate any help. Thank you.

**jindon** · 06-21-2018, 08:39 AM

Change
to

Please Login or Register  to view this content.

**Andrew.Trevayne** · 06-21-2018, 09:09 AM

Originally Posted by jindon

Change
to

Please Login or Register  to view this content.

Super thanks! Much appreciated.

**jindon** · 06-21-2018, 09:12 AM

You are welcome and thanks for the rep.

When range to be deleted (rng) is nothing, you can not delete it, so error.

Runtime Error 91: Object variable or With block variable not set

LinkBack

Thread Tools

Rate This Thread

Display

Runtime Error 91: Object variable or With block variable not set

Re: Runtime Error 91: Object variable or With block variable not set

Re: Runtime Error 91: Object variable or With block variable not set

Re: Runtime Error 91: Object variable or With block variable not set

Thread Information

Users Browsing this Thread

Similar Threads

I m getting the error: Runtime error 91: “ Object variable or With block variable not set”

Runtime Error 91 Object Variable or With Block not Set

Runtime Error 91 - object variable or with block variable not set

runtime error 91 object variable or With block variable not set

Runtime Error '91' Object variable or With Block variable not set.

Runtime error 91 - Object variable or with block variable not set

Bookmarks

Bookmarks

Posting Permissions