Snoopy369 wrote:
Not sure why the name isn't working ...


Nor am I, but I would try putting Err.Clear before the Set wks = ...
line; you may be picking up a different error than the one you were
looking for.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup