Run-Time error '9' Subscript out of range

**wahi00** · 07-29-2014, 04:42 PM

Hello,

I get a run time error when I run the macro below at the point where it says windows(TFile). Activate. The macro starts with looking in the server and pulling in the updated files. Then it opens up one of the updated file to copy into the current file and that is where the error occurs. What am I doint wrong? Any suggestions? I would appreciate it.

Thanks
Dee

Please Login or Register  to view this content.

**majosum** · 07-29-2014, 06:18 PM

I assume "TFile" is the name of the current workbook? First, check the file name ("RR Upload.GA006.ULV.xxx.GA.SA BOLI.xlsm") and ensure this is 100% accurate. If it is accurate, then maybe try moving the IBook.Close line before the Windows(TFile).Activate line and delete this aforementioned activate line. If you close the IFile workbook, only the current workbook will be open anyway.

**pareshj** · 07-29-2014, 09:56 PM

Hi,

Try the following code instead of Windows("xxxxx").Activate

Please Login or Register  to view this content.

Where,
SheetName = Sheet you want to activate.

Similarly do it for Windows(TFile).

Regards,
Paresh J

Run-Time error '9' Subscript out of range

LinkBack

Thread Tools

Rate This Thread

Display

Run-Time error '9' Subscript out of range

Re: Run-Time error '9' Subscript out of range

Re: Run-Time error '9' Subscript out of range

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Run-time error '9': subscript out of range - error occurs on multiple computers except one

[SOLVED] Run-time Error '9': Subscript out of Range

Run time error 9 - subscript out of range

[SOLVED] Run Time Error 9 - Subscript out of range

run time error 9 : subscript out of range

Bookmarks

Bookmarks

Posting Permissions