subscript out of range

Hi, I am facing a peculiar problem. I have built excel VBA macros for various functionalities like create dynamic excel workbooks based upon userform input values and some manipulations as required. Now, when this VBA Macro excel sheet is open (not running). I am not able to copy any cells...

Hi all - first, let me say this is an enormously helpful forum! For weeks I've found every answer I needed without even registering. I will be sure to contribute back as/when I'm able! I have an issue using a variable as a worksheet name. I have code finding the first name of a user from...

Hello. I partly created a code which tries to group data based on the values of an array. The problems are that I'm trying to extract data from multiple worksheets that belong to the same workbook so ReDim Preserve seems to fall out of range when the code reaches the 2nd worksheet. I'm not sure...

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

Hi All, I've scavenged some code from a forum and I'm getting a subscript out of range error and I'm not sure what's going on. I'm really pretty new to VBA so go easy on me please. Also, sorry for the code snippets not being up to snuff in terms of formatting...I couldn't get the MrExcel add...

I've got a macro that I recorded (because I don't know how to write one) that just copies certain columns from one tab into another. It's been working until today, where I get a" subscript out of range" error and it goes to the highlighted section of my code (below). I think the issue is that...

Hi there!!! I am creating spreadsheets for several cost centers. Each cost center has a number of departments. Some cost centers have 2 or 3 departments; other cost centers have as many as 15 departments. I have a macro that will automatically add 3 worksheets in the workbook for each...

I have this code for comparing two columns, finding repeated entries, and deleting the row where the entry is repeated. I've tested it on a small data base (<50 entries) and it works. However, when I apply it to a larger database (>300), I'm getting an error: "Subscript Out of Range" Sub...

Today's not my day :P Here's post number 2...I've created an error handler to create a worksheet if it doesn't exist. It creates the spreadsheet and names it after the year of a date that I've captured. On the line I've marked below, it gives me Run-time Error 9. I know it's catching on the...

I'm trying to use this macro to copy data from one unknown workbook and paste it into another (also unknown). It should pop up two userforms, the first asking which file to use as the source and the second asking which file to use as the paste target. I trimmed off the .xls file type (although...

Hi, I have a Excel/VBA script written 5-6 years ago on a Mac running Excel -- probably 2003. (It is not an option to go back and work on that Mac and software version.) I need to get this to run in Excel 2007 on a PC. This is my first time debugging VBA scripts. I've been able to remove some...

Hi folks, I did look at the other threads about this but couldn't find an answer within. My situation is as follows. I have a sheet that generates a list of file names to be imported into different sheets, I'm writing code to loop through the sheets and import them all into each (each list of...

Hi, i tried to solve a problem appeared to me before and another came up. I have set a UserForm with ComboBox for multiple selection items. I use 4-5 subroutines in a row so the UserForm user to select a specific value. Depended ComboBox in other words. The error i get is that of "Subscript out...

Hello Folks, I a Newbie in Excel VBA. Lately, I am trying to sort some data in my workbook with Excel VBA. I am sorting this data on Column C (Name) But I keep getting Subscript out of range error on the first line itself Can you please guide me? Thanks in Advance!! My data is in...

Error: 9 - Subscript out of range I have written the following code , it was working before on my Test Excel sheet when I tried to run on the live xl Sheets i.e. Source and Destination its giving me above error on the line(red font) given below: Aprreciate your help. The code is written in...

I'm trying to write a copy and paste program that lets the user select which xml files to merge and then in sequence opens up the xml file selected second and paste it into the first selected file (top file in final completed file), opens the xml file selected third and paste it into the xml...

Hello Forum I am trying to loop through a doc. I want to test/match every item in the column against the first item, then loop and then test/match every item against the second item...and so on... and so on. I can successfully go through one column all the way to the end testing every item...

Hi I am trying to read data into an array for various reasons but I get the subscript out of range error. I know the array is not dimensioned but the problem is that on each loop I do know know how many elements will be read. I assume that if I dim the array to 10 then the Ubound will...

This relates to a project which uses multiple sheets, named SL 1, SL 2, ..., SL 99, SL 100, etc. This is a contiguous sequence. A section of code is supposed to scan through all the sheets to identify the final sheet, whereupon other actions will occur. This fails with "Run Time Error '9'" on...

Hi, I am trying to copy just the values from one range in one file to another file with the same range name, I wonder if this is at the origin of the "subscript out of range" error message I get. Here is the code, where it stucks is in red: Sub UpdateToFinalFile() Dim ws As Worksheet...