trying to copy quantities without using copy paste? "subscript out of range"

**jestalavita** · 02-09-2014, 06:48 PM

gday,
I have posted this problem a few days ago and marked it as solved but when i tried to use the process on another emailed list it came up with "subscript out of range".
I have attached the new email that is in a bit of different layout. I beleive this to be the reason. I have attached original also to see the difference in layout. Ill also attach the program that alansidman wrote/posted for me .
The program worked on the original, but wont seem to work on others.
Is this problem because of the way the second list is written or is there something i have done wrong?
The program duplicates the labels and copies them in a list in multiples of quantities

**alansidman** · 02-09-2014, 08:19 PM

the code that I wrote for you was specific to the layout of the spreadsheet. VBA code that was expressly written for one spreadsheet layout/design cannot be expected to perform the same on a radically different layout. You have two options.
1. Change the layout of the new list to look like the old list
2. Write new code specifically for the new layout.

I would urge your providers of data to submit the information in a standardized format so you don't have to keep rewriting code.

**jestalavita** · 02-09-2014, 09:34 PM

thanks for the replies. i am going to try learn to write codes. im beginning with youtube tutorials but am VERY novice with computers. any suggestions or just keep at it.
thanks again fella

**alansidman** · 02-09-2014, 09:46 PM

I would pick up a good VBA book. Look in the Tips Subforum here for some guidelines.

trying to copy quantities without using copy paste? "subscript out of range"

LinkBack

Thread Tools

Rate This Thread

Display

trying to copy quantities without using copy paste? "subscript out of range"

Re: trying to copy quantities without using copy paste? "subscript out of range"

Re: trying to copy quantities without using copy paste? "subscript out of range"

Re: trying to copy quantities without using copy paste? "subscript out of range"

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copy multiple rows that contain a certain "name" in column "A" then paste it into new work

[SOLVED] "copy paste" using "=" but its only pulling the first value of the selection?

[SOLVED] Loop to check for "yes" then copy the IDs with "yes" and paste to other workbook

Error msgs: "Object varible or with block variable not set"; "subscript out of range"

[SOLVED] "Subscript out of range" error for: Workbooks("Test1.xls").Save

Bookmarks

Bookmarks

Posting Permissions