Dealing with million plus blank rows

Hello, everyone! I'm having some trouble with a macro that I inherited from my predecessor. Basically, the issue is that, after the macro has successfully completed, it ends up adding the max amount of blank rows possible in Excel (over a million). I'm still a VBA noob, so I kinda feel overwhelmed with the code. Currently, I just have a separate macro that's deleting the rows after the main macro has finished running. It works, but it isn't pretty, since you have to use two macros, just to get the end result that you want. The best solution would just to know how to code the main macro, so it doesn't end up inserting the blank rows. The second best option would be merging the "DeleteBlankRows" macro with the main macro.

Please Login or Register  to view this content.