Run-time Error '91' Object Variable Not Set
 

I am having alittle trouble with this coding. When I run it it end
with a runtime error. I have it save the workbook and close it at th
end. I believe the code is trying to still run when this happens. Ca
anyone tell me how to stop this. See coding. Sorry it is long.
<--------Newbie on board. :)

Attached is the coding.

Thanks in Advance,
Chri

+-------------------------------------------------------------------
|Filename: INSERTSERIAL.zip
|Download: http://www.excelforum.com/attachment.php?postid=4314
+-------------------------------------------------------------------

--
zero63
-----------------------------------------------------------------------
zero635's Profile: http://www.excelforum.com/member.php...fo&userid=2480
View this thread: http://www.excelforum.com/showthread.php?threadid=50825