Thank you so much for your help. I so appreciate it!!

On the second part of my post, I was referring to a User Form that I
had created. I used two command boxes - one to dump the data into the
spreadsheet and the other to close the form. If I click the mouse
outside of any of the User Form cells or command buttons, the error
occurs. I'm sure there's some way to work around this, but I haven't
figured it out.


--
MarianneR
------------------------------------------------------------------------
MarianneR's Profile: http://www.excelforum.com/member.php...fo&userid=6253
View this thread: http://www.excelforum.com/showthread...hreadid=475191