the code doesn't know which sheet you are refering to. the code has
been running with the focus on the userform and the the code doesn't
know which sheet in the workbook you want to work with.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=182456

Microsoft Office Help