none
Macro run time errors. RRS feed

  • Question

  • I'm receiving a "Run-time Error '9' Subscript out of range. I have checked the the correct details but it won't go past this section where its meant to enter the data on another sheet.

    Prior to this entry there is a few hundred entries. I'm just adding extra into the macro. the previous items work ok.

    Sheets("Data").Select
        Range("NE6").Select
        Application.CutCopyMode = False
        Selection.Copy
        Sheets("Description").Select
        Range("H107").Select
        ActiveSheet.Paste
       
        Call LoadVISdata2
       
        End Sub
       
        Sub LoadVISdata2()
       
       
       
        Sheets("Data").Select
        Range("NF6").Select
        Application.CutCopyMode = False
        Selection.Copy
        Sheets("Work review").Select      (it stops on this line) the Work review is spelt exactly the same as the work spread sheet)
        Range("D26").Select
        ActiveSheet.Paste

    Wednesday, March 11, 2015 6:24 AM