runtime error 9

  1. 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...
  2. 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...
  3. 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 <...
  4. 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...
  5. 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...
  6. 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) &...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top