run-time error '9'

Hi, I have code in my main spreadsheet which works fine, no problems at all, until I open another spreadsheet. If two or more spreadsheets are open and I do anything in any of the spreadsheets (select from drop down menu for example) it produces "Run time error 9 - Subscript out of range"...

I am trying to set an open workbook as variable book2 but keep getting a 'Subscript out of range' error. Below is the code I am working with. It errors at 'Set book2'. It's completely random and will work sometimes but most of the time it doesn't. Could someone help? Set book1 = ActiveWorkbook...

I am having an issue trying to figure out this debug error. I get Subscript is out of range when we add an entry into table for LOBName. We have a total of 101 entries right now. If we remove the last one it works but throws an error as soon as we add 101. This line highlights yellow...

Hey MrExcel Community! Long time browser here, you guys have basically taught me VBA 101(thanks!) but first post as I can't seem to find my specific problem in other threads. I'm an actuary, definitely not a coder, and am trying to make a simple button/program to keep a main 'Outstanding...

I am attempting to have a user form where the user clicks on a button to Add content into a worksheet. The code is as follows. 'Summary: Button for User to Add DAA. User clicks button and userform1 appears. 'User adds DAA, Career Path, Moves applicable Skills and Strengths to the right listbox...

I have run into the problem with ThisWorkbook.Worksheet function. I started doing tutorials by VBAIsFun on youtube and I am running into trouble with this function. Here is the tutorial that I am having trouble with : Excel VBA Basics #7 - Using specific sheets, Hiding, Unhiding and Selecting...

Hi, I am trying to write an ErrHandler code but am having a few issues. Basically I want the Err message to delete a worksheet called "Scorecard" and one called "Comparison" if they exist. If they don't then I would like the macro to continue. The macro I have written scrapes a website and...

I'm receiving a Runtime Error '9' Subscript out of range when I try to run run the below code. I've tried changed the Range("A5").Select but that didn’t help. The code below was created using the macro recorder. This is the part that is highlighted when debugging Windows( _...

just inserted the code and now I get run-time error '9': subscript out of range. any ideas? Private Sub Workbook_Open() Select Case ThisWorkbook.Sheets("aiiwwaxexcel0").Range("a3").Value Case "History" History_Order_Guide_Without_Pricing2 'macro that runs Case "ItemBrowse"...

Hi, I have a Excel/VBA script written 5-6 years ago on a Mac running Excel -- probably 2003. (It is not an option to go back and work on that Mac and software version.) I need to get this to run in Excel 2007 on a PC. This is my first time debugging VBA scripts. I've been able to remove some...

Hello all: First post. I'm using VBA in Excel 2007. I have been trying to code a subroutine to find the last sheet and the sheet names of the tabs in a workbook. Then I'm attempting to place those sheet names in an array. I suspect that I'm not using the right class of object or the right...

Hello, I am working with Excel 2003 on Windows XP. I have a master workbook with 14 different worksheets and I am trying to create 7 different workbooks from it; two sheets per workbook. To give you an idea of what I'm trying to do, I've outlined 8 of the worksheets below: Equipment...

On occasion, I run my macro and receive this error that indicates "Subscript out of range"....with no option to Debug. I then close the excel document, re-open and run the macro again and no issue what-so-ever. :confused: Any ideas?