this line fails:
I wrote this for a friend who uses XL2003 at work.Workbooks("Book1").Sheets("Sheet1").Activate
It runs fine on my XL2000 at work and my XL2007 at home but he gets an error on his XL2003.
Unfortunately, I have no access to XL2003
We have 3 workbooks open at the time this is running. He gets the error whether or not the active workbook is Book1 when this line runs.
Bookmarks