Put the following line of code at the top of your module, if you don't
already have it:

Option Explicit

Then declare all variables and fix compiler errors.

Step into the code when the error occurs and let us know what line the
error occurs on.
I see a line of code "GoTo Line1", but I don't see any "Line1:" anywhere
in the program, for starters. When the code ends up on this line, is it
OK for the code to goto the very 1st line in the entire module and
restart there? This may not be what you want. Normally, a labeled line
would be something like:

If cond _
then
'Do something
else
Goto ContinueMyProcessing
end if

ContinueMyProcessing:
'Continue other processing here.
--
Regards,
Bill Renaud