"Subscript out of Range" error occurs when you try to refer an arra
element or objects collaction that is not defined.
For example, you refer to myArr(15) when myArr is defined as
Dim myArr(10).

Here, may be you are trying to refer ActiveWorkbook.Sheets(3) wher
there are only 2 sheets.

So, check up all such statements in code

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