The code looks fine to me.
Have you checked you have the worksheet names correct?
By the way what do you mean by Workbook.Range().
As far as I know worksheets have ranges not workbooks.
mleone Wrote:
BTW this is Excel 2002.
I didn't see any Workbook.Range()
I think that's why its not working.
--
Norie
------------------------------------------------------------------------
Norie's Profile:
http://www.excelforum.com/member.php...o&userid=19362
View this thread:
http://www.excelforum.com/showthread...hreadid=379003