Have to run macro twice, in order for it to work?

[cluelessdood]

Hello, everyone! Having some trouble with a macro I've been working on. It's used to delete blanks (over a million blank rows) when another separate macro is run. If I get this one working, I would like to merge the two macros together.

First time it is clicked, it loads and acts like it's going to work. Less than a minute after loading...nothing happens (at least, visually). I click it again and it runs quickly; this time, it works.

Here is my very simple code:

Please Login or Register  to view this content.

[Keebellah]

What happens if you deactivate the On Error resume next?

[cluelessdood]

What happens if you deactivate the On Error resume next?

I just tried it. I still have to click it twice.

[Keebellah]

No error message?

Have you gone through the VBA step-by-step?

[cluelessdood]

No error message?

Have you gone through the VBA step-by-step?

Yep, no errors are popping up. Do you think it's the first macro that is having some effect on this one?