runtime error 9

Help! This is the most ridiculously big brained problem I've ever run into. I'm not sure where or when the problem came about, but all of a sudden I can't reference one of my sheets anymore! The only way I can get VBA to run any code that has to do with range references or object references to...

Good morning all, I have a spreadsheet that I've used for several weeks - it worked just fine yesterday in fact. Today I turned my computer on, opened the workbook, and suddenly I'm getting a Subscript out of Range error for the following line: With ThisWorkbook.Sheets("Job Results") ''some...

I'm not sure what I'm doing wrong when entering this code, but I did use it before and I'm not sure what I did the last time. Basically what i'm trying to do is to copy a range of columns and paste them into another set of columns. When I type the macro the error comes up for the first line...

Hello All, I want to combine a specific tab ("Summation") in all workbooks in a folder to a single workbook. I have my macro asking for the file path, a file name pattern and the tab name from each workbook. The only 2 I really need are the file path and the tab name but the middle is just...

I have written a simple VBA Code in one workbook, that works well. However, if I am still in that workbook and open up a new workbook (which hasn't got any macros or VBA), I get the Runtime Error 9 message. It highlights in the VBA Code the following line: If Sheets("IFAs").Range("F3").Value <...

Hello all, I'm trying to run macros in Excel 2011 (Mac) that worked fine in Excel 2004 (Mac). I have OS 10.6 on a Macbook Pro. The line of code causing the error is: Trial = Worksheets(Subject).Cells(I, 1).Value Where subject is string containing numbers (e.g. 801); I is an integer and a...

I changed the activewindow.caption and in code in another vba project. Now I have saved the name of the current spreadsheet and activate another spreadsheet. Then when I try to go back to my original spreadsheet, I get the error, "Runtime Error 9 Subscript out of range". But the name of the...

I'm struggling to explain an error message I'm getting when I step through some code I've written. The code below gets a 'sub script out of range' error and I'm not sure why... For i = 1 To 16 Workbooks(dataArray(16) &...