I have had a similar error. It had to do with my script opening a secon
workbook (and activating it), but I still referred to the firs
workbook (which contained the script) as the ActiveWorkbook.

I don't know if this is similar to the problem you are experiencing
but maybe it helps you...

--
Message posted from http://www.ExcelForum.com