As mentioned in the title I am trying to extract lines from multiple worksheets with the word Order in column F. I have managed to do this except when there are more than 37 orders on one sheet it will come up with the error:
"Run-time error '1004':
Method 'Range of object'_Global failed"
I have attached the excel file so that so can look through the code, and hopefully see where I am going wrong.
New Sheet.xlsm
You stand a better chance of getting help if you upload the "problem" file.
Alf
or at least post the code ;-)
Josie
if at first you don't succeed try doing it the way your wife told you to
Cheers Alf
New Sheet.xlsm
the address you were passing to the Range property was too long
Please Login or Register to view this content.
Cheers JP
Though that might be the case. Couldn't think to how to rewrite it. Anyway you are a genius. Cheers mate
Try this code
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Please Login or Register to view this content.
Arlu couldnt get yours to work, and jindon your code seem to copy the results four times. Anyway managed to get it working thanks to JP with his code. Thanks for both trying though, much appreciated. Here it is if you were interested:
Please Login or Register to view this content.
Last edited by arlu1201; 04-16-2013 at 01:36 PM.
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.
When you say mine didnt work, was it giving you an error on any row of code?
Also, its against the forum rules to duplicate threads. This time i will merge the threads for you. If our codes were not working, its better if you mention it that its not and provide the line to us which is giving you the error. By duplicating threads, you are duplicating efforts, which could have been used on some other thread.
Is shouldn't.Originally Posted by Megabruce
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks