OK,

Sorry for so many replies.

It works!

After my last reply, (I finally began to think); I placed that code in
the module section, out of this workbook, and it worked fine.

Well I got an error at first, and it pointed me to
Sheets("Sheets1").Select. I just took the s out of the sheets1, and
bingo, it flew.

Thanks again for all of your support. 3

EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=374141