Alisha,

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.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Alisha" wrote in message
...
Run time error 9
subscript out of range

does ne1 kno wat this means?