View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anamika[_2_] Anamika[_2_] is offline
external usenet poster
 
Posts: 1
Default URGENT!!!!!!!!!!!!!!! Problem with macros in Excel

H

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 hel