runtime error 9

  1. lockarde

    Suddenly getting Subscript out of Range error

    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...
  2. C

    Runtime error 9 excel macro

    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...
  3. S

    Combine multiple sheets with same name from seperate wbs in a folder into one workbook

    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...
  4. P

    Runtime Error 9 When Opening Up Another Excel File

    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 <...
  5. E

    Subscript out of range after switching to Excel 2011

    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...
  6. M

    Runtime Error 9

    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...
  7. P

    VBA runtime error 9

    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) &...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top