is Sheet2 the name of the sheet or the name of the workbook.

anyway, a subscript out of range error says you are providing an argument to
Windows or other collection which is invalid. For you example, there is no
workbook with the name Sheet2.xls

--
Regards,
Tom Ogilvy


"Anamika" wrote in message
...
Hi

I wrote a macro in excel "sheet1" .What this macro does is to export data
from one Excel "sheet2" to "Sheet1". It was working fine in all systems.
till 2 days back. But now it works in some and it doesn't work in some
systems.

It gives an error saying ""Runtime-Error '9' Subscript Out of Range." .

At this line i am actually activating the sheet from whcihc it has to
copy. Ie " Windows("Sheet2.xls").Activate"

Some one pls help