Macro runs successfully but displays "Out of Memory" error at end

So I am creating a macro that I provide for a number of users to run on their own computer. In this version of the macro, I included some code that brings in a macro from a workbook at a different location to the "ThisWorkbook" module so the code executes upon the user saving their file.

The macro does some other generic stuff as well, but in testing this macro, occasionally I get an "Out of Memory" error after running the macro, but the macro still completes successfully. Any ideas on what the issue could be? Is it stemming from the added code below to bring in the macro from a different file as I wasn't typically getting this error before with this macro.

Please Login or Register  to view this content.

Or .. place OPTION EXPLICIT at the top of the macro and see if there is an error that VBA recognizes.

Taking a stab here ... does this line

Please Login or Register  to view this content.

run though
all 1.4 million rows of the worksheet ? If so, perhaps that is causing the out of memory issue ?