run time error 9

Hello, I am trying to perform a VLookup function within Xcel. I read in a string that the user selects in the UserForms portion. I am able to store that as a string, and write to a cell. However, when i want to look that string up in my data tab (sheet2) to return a specific value, i am...

Hi I have the following section of code within a large macro: Worksheets("Dubai Data").ActivateActiveCell.Offset(0, 2).Copy detail = ActiveCell.value Sheets(detail).Select ActiveCell.Offset(-2, 1).PasteSpecial xlPasteValues ActiveCell.Font.Bold = True Range(cells(ActiveCell.row, "C")...

I'm pretty new to VBA, so I'm not too familiar with the errors and exact coding rules. I'm getting a Run-time error '9': Subscript Out of Range when I use this macro: Sub CopyStuff() Range("d4:I15").Copy Workbooks("C:\Users\emyyra\Desktop\Random...

This is my first post as a new member. I have read a great many previous posts in the past and found the information to be very helpful. However, this time I have not been able to find an answer to solve my problem. My problem is that I get the Run Time Error 9 after adding a new file and...

Hello all, I am using Excel 2010. I am attempting to run a macro as a 'Before Save' event in a workbook named "FirstWorkbook.xlsm." Among other things, the macro opens up a separate workbook ("SecondWorkbook.xlsm"), copies a range of data from the first workbook, pastes the data into the...

This error message pops up when I run the macro, "Run-time error '9': Subscript out of range" I was wondering what could be wrong with the code? "Sheets(sheetName).Activate" is highlighted. THANKS!!! Here is my code: Function calAutoNumber(sheetName As String, StartCol As String, startrow As...

All, Apologies for the vague title - could not find a good way to word it. This thread plays off a recently posted one that a member was very quick to answer and get me on my way. I have a file name of "May Scrap Net of Reserve with scrap codes.xls". My earlier post centered around how to...

I have a Userform that runs a macro to perform a series of operations by reading data from a database I created in the same workbook but on a different sheet. If I have other excel files/workbooks open when I run the macro via the Userform, I get a 'Run Time Error 9: Subscript is out of range'...

I have a lot, a lot of data to sort. I need to search column U for products and then move the row information to a new workbook for each product. There are over 1,000 different products and each one has numerous entries that are randomly distrusted within column U. So far this is what I have...