After it runs through for about 40 rows we keep getting this error from my macro
Sloppy writing again.

You did not tell us what "This Error" was, all you did was show us where the Error occurred.