This error typically occurs when you are attempting to retrieve,
by name, an item from a collection, and no item by that name
exists. For example, the following code will raise an error 9 if
there is no sheet named 'Sheet4'.
MsgBox Worksheets("Sheet4").Name
You might want to post the code that is causing the error.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
