Hello,
I have gotten the error "Subscript out of range" for the lines within the With statement in my code, but I can't seem to figure out what is missing/wrong.
The macro is supposed to get the data from multiple sheets in one workbook and paste it is a single sheet in another workbook.
If you can spot it please let me know.
Please Login or Register to view this content.
Is your destination workbook named "Name" ?
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]
perhaps
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Yes, arlu1201 "Name" is where the data is going.
Thanks JosephP, that worked!Originally Posted by JosephP
perhaps
Please Login or Register to view this content.
It copied the format of the cells in the source workbook though (green cell) is there a way to do paste special > values within the .copy destination:= part?
don't copy and paste
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