That would be true if the activeworkbook doesn't have a worksheet with a name
of LIST.

--
Regards,
Tom Ogilvy


"Papa Waigo" wrote:


Thank you for your help here

This code gives me a "subscript out of range" error

any ideas?


--
Papa Waigo
------------------------------------------------------------------------
Papa Waigo's Profile: http://www.excelforum.com/member.php...o&userid=36074
View this thread: http://www.excelforum.com/showthread...hreadid=558861