Macro runs slow and adds blanks

[cluelessdood]

Hey, guys! I came here a few months ago and you all were awesome with the advice you provided. I have a macro that is adding millions of blanks. I added a sub that would delete the blank rows, which works great. However, my customer is wondering if the macro could be sped up. I'm still learning VBA and I inherited this code, so I'm trying my best not to change a whole lot a wreck the whole thing. Basically, I just want to stop the macro from adding blanks in the first place, rather than adding more code that deletes the blank rows AFTER the fact (which I feel would slow down the macro's speed).

Here's the main code that I'm working with:

Please Login or Register  to view this content.

I've gone over it numerous times and I can't see anything that would insert millions of blank rows. Any help would greatly be appreciated. Thanks.

[banaanas]

Could you attach the workbook?

[jolivanes]

https://www.mrexcel.com/forum/excel-...ng-blanks.html