I am attempting to paste a range to a 2nd workbook and i am getting an error (Application defined or object-defined error) on highlighted line in code below.
I am not VBA educated..so any help would be appreciated.
Please Login or Register to view this content.
Last edited by SLIDE1; 10-10-2012 at 02:05 PM.
Just throwing something out here, but could it be that an XLS file doesn't have 1048576 rows? They only have 65536 rows.
It was originaly 65536..didn't work so I changed it hoping it would make a difference. It didn't of course and I forgot to change it back.
You didn't copy anything to paste!
Please Login or Register to view this content.
I missed a couple of lines of code in my original post. code is now correct as I tried to run. with no luck.
Last edited by SLIDE1; 10-08-2012 at 03:15 PM.
It happens to the best of us brother.
Bumping in hopes of a suggestion.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks