Curtis, I'm glad your problem is solved! (Maybe we ought to get your
co-worker here on the NG, so he can solve *my* problems, too!! <G )

I've had others stick with me and help me work through code issues - it's
how I've learned most of what I know about VBA. That, and helping others.

Take care.
Ed

"Please Help" wrote in message
...
Ed,

A co-worker has solved my issues. I wasn't being clear when defining the
ranges (CWeek, CCPI, etc..), for each statement I had to specify the
workbook
and sheet, rather than using the activesheet method. Thanks again for all
of
your help! It was very cool of you.

Curtis