Hey all,
I have been reading through the forum and can't seem to find exactly what I am looking for. I have tried a couple of suggestions that are similar but not working.
I realize this is basic, but i am having a hard time with it.
I am trying to copy data in range AA3:AE8 in workbook 1 and paste it into workbook 2 in range C3:G8
Here is what I have, but get and out of range message.
Thank you for all your help,
Please Login or Register to view this content.
Matt
I haven't tested this, but ... you might try something like:
P.S. If the above code doesn't work, you might try uploading a workbook.Please Login or Register to view this content.
Last edited by StevenM; 07-24-2012 at 02:51 PM. Reason: Added a P.S.
Attach the sample file which you are using along with the code. It will be easier for us to troubleshoot.
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]
OcMac
many lines of your macro are useless, try this
Please Login or Register to view this content.
Last edited by patel45; 07-24-2012 at 02:56 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks