Run Time Error '9' - Subscript Out of Range.

**joyjyothi** · 10-09-2018, 04:19 PM

Hi All,

I am new to VBA and Excel Programming. I encountered the 'Run Time Error '9' - Subscript Out of Range' error while i tried to load the data. This is existing code. This code was written in Year 2010, I am not sure recent upgrade may causing this error.

code is

Please Login or Register  to view this content.

Thanks for you help.

**romperstomper** · 10-09-2018, 05:07 PM

Does your new workbook only have 1 sheet in it perhaps?

Also, please use code tags when posting code.

**lexusap** · 10-09-2018, 05:58 PM

Hi,

when you perform

Please Login or Register  to view this content.

, check how many sheets it creates? if it only create 1 sheet, then

Please Login or Register  to view this content.

will fail, you need at least 3 sheets to perform your code, since you code specifying changing sheet1 , 2 and 3 to different name.

Also, please use Tag Code

Thanks
Lex

**joyjyothi** · 10-09-2018, 08:02 PM

Hi All,

Thank you for your response. What is mean by code tags.
Initially it has only one sheet, Now i have added two more sheets and named them accordingly.

Still it is failing at sheet2.

I have been executing this code for long time. I never faced this issue in past. But I we migrated to latest MS accesses. Is this causing issue?.

Thank you

**alansidman** · 10-10-2018, 12:35 AM

@joyjyothi

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html

(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

**romperstomper** · 10-11-2018, 02:09 AM

It’s an Excel setting. If it’s set to only use 1 sheet by default, your code will always fail. You should test how many sheets there are in the new workbook before you use them.

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.

Re: 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

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 - error occurs on multiple computers except one

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

Run-time error '9': subscript out of range

Bookmarks

Bookmarks

Posting Permissions