I see where you were going with that but I dont believe you have to state the
workbook in the code as it is usually understood when working with only one
workbook. I went ahead an tried your advice and the problem continues.

Signature
Fighting Texas Aggie Class of 2009
> i believe that when you start specifying sheets, you also have to
> specify the workbook..................
[quoted text clipped - 57 lines]
> >
> > Fighting Texas Aggie Class of 2009
Susan - 20 May 2008 19:34 GMT
ok.
all i can come up with are other award-winning suggestions like "are
you sure you have a worksheet by that name in the workbook?", which
you probably do.
i looked at some other posts on run-time error #9 & couldn't come up
with anything else that might be causing it for you.
might be something basic like "worksheet" instead of "worksheets".
sorry can't seem to help you out.
susan
> I see where you were going with that but I dont believe you have to state the
> workbook in the code as it is usually understood when working with only one
[quoted text clipped - 65 lines]
>
> - Show quoted text -