subscript out of range

Good morning! I have a "Subscript out of range" issue. Background: working in Excel 2007 with an SAP BPC Add-In (BPC was formerly known as OutlookSoft). I know very little about VBA. We have a file (call it file #1) that contains the following VBA: Function AFTER_SEND(Argument As String)...

How would I assign an unknown sheetname to a variable so that I can go back to the worksheet again in my macro when I don't know what the name of the sheet will be (the sheet is being added during the macro?) I was trying to do someting like this, but I keep getting a Runtime Error 9 subscript...

I have the following code in my workbook. I want it to take the values of cells in the current workbook and scroll through another workbook to see if the value is present in there, and then perform a function if it is - else do nothing. The line preceeded with a lot of ***** is the line...

Hello Forum! I would like to delete all except one sheets in the workbook by pressing onto a button. So I wrote the folllowing code (its obviously only a part) Application.DisplayAlerts = False For Each Worksheet In Worksheets If (Worksheet.Name <> "Instructions") Then...

Hi, On the change of a combobox that lists all worksheets within the current workbook, I am trying to dynamically populate a list box on the same form, from data contained in the 1st row of the chosen worksheet. I am receiving a "subsript out of range" error on the .AddItem MyList(i)...

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