OK, Excel gurus...I am about to explode and for the life of me I am puzzled. The below script works on a different workbook but not on this.
PLease help. Basically I am trying to copy the data from one sheet (Sheet1) to Sheet 4 into a different workbook. I can't see why I get an error.
It looks like it gives me an error at the ActiveSheet.UsedRange.Offset(1, 0).Copy bit! Application Defined or Object Defined” error '1004
Please Login or Register to view this content.
Thanks a lot in advance
seee if help.
Please Login or Register to view this content.
Thanks a lot Ikboy. I still get an error after the '**** Activate copy paste though.
"Application-defined or object-defined error
firstly you have to park my code into yours code and make sure all workbook's name and sheets name is right then.
Ikboy/Hawk,
I'm curious why you chose the ws1.UsedRange.Offset.Copy method instead of ws1.copy. I'm new to VBA.
Also, why the Offset? If you're getting an error at that line, I would try: ws1.UsedRange.Copy and leave the Offset out of it, unless there is something I'm missing. If not, I'm curious about why the Offset is used.
Thanks,
Joe
Last edited by joe31623; 01-14-2016 at 04:05 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks