Hi!
i have a code that copies a range and specific cells between two worksheets.
Could somebody help to adjust the code so as to copy the same procedure between two workbooks??
Any help would be much appreciated!
Thank you very much in advance!
Please Login or Register to view this content.
Hello fcb1900,
It would help to know if the worksheet names and ranges are same in the other workbooks as your example. Here is a macro based on your current example. You will need to add the destination workbook name to the macro (name is in bold). The source workbook is assumed to be the workbook the macro is in.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I changed the ranges and i'm getting an subscript out of range error!
Does this happen because the ranges between the 2 workbooks are not the same or the same format?
I attached both workbooks and here is my code
Could somebody help to adjust?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks