Script out of Range

**Syed Haider Ali** · 09-23-2007, 06:25 AM

Dear Folks

I have the following codes to generate a stock report in worksheet "CottonRegister" based on Worksheets "CottonPurchase" and "CottonIssue". It is working well in my PC, but when I copy theses worksheets to my PC at office at the same path i.e at Drive C:\ and run the Program it stops at line " Application.WorksheetFunction.SumIf(Workbooks("CottonPurchase").Worksheets("CottonPurchase").Range("d:d"), Cells(x, 1), Workbooks("CottonPurchase").Worksheets("CottonPurchase").Range("g:g"))" saying that Run Time Error 9 and script out of range.

Please Login or Register  to view this content.

**WinteE** · 09-23-2007, 11:54 AM

Hi,

Are all 3 files opened correctly at the beginning of your code ?

Is there a particular reason why you store these files on the root drive C: , and is the file that contains this code also on C: ?

Erik

**Leith Ross** · 09-23-2007, 12:03 PM

Hello Syed,

You don't mention what the value of x is at the time of the error. Is it failing as soon as the loop starts or later on? Place a breakpoint at that line by placing the cursor next to the line and press F9. When the macro runs, you can then step through x, and see if fails at a particular value. If the code is failing as soon as the loop starts, check which sheets are active in each workbook at home, and at work. If the office copy is different, have the code activate the same sheets before the macro runs.

Sincerely,
Leith Ross

**Norie** · 09-23-2007, 12:30 PM

Try adding the xls file extension when trying to refer to the workbook(s).

Note this could easily be avoided if you created references to the workbooks when you open them.

For example:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I would also warn you that you could run into problems due to unqualied references like this.

Please Login or Register  to view this content.

PS Oh, and you don't need to use Select.

Script out of Range

LinkBack

Thread Tools

Rate This Thread

Display

Script out of Range

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions