I have the following code that is meant to copy and paste certain values from one workbook to another, but I need the macro to make a list in the workbook being pasted into by always pasting on the next available line. I keep getting an "Object Required" error with my current code and I can't figure out what to do.
Any help would be greatly appreciated!
Please Login or Register to view this content.
Thanks!
Last edited by arlu1201; 06-04-2013 at 02:03 AM. Reason: Use code tags in future.
You first want to copy D3 from one file to the next available row in column A in file 2? Then copy N24:T25 to the next available row in column A in file 2? Then again copy N30:T31 to the next available row in column A in file 2?
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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks