Hi I have the below code to iterate and copy/paste data.
This works fine, but I always get a message saying:
Please Login or Register to view this content.
"Data on the Clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway?"
The method completes when I click OK, but I am having to do this hundreds of time as there are a lot of files to be created.
Is there a way to stop this message?
With Thanks.
Try this.
By the way, where are you running this code? Access? Word? Another application?Please Login or Register to view this content.
If posting code please use code tags, see here.
That was it, thanks! I was running it in Excel. It is odd that this is the solution, as it is going against that the error message is saying, in that both the copy size ("A:U") must be same as the paste area ("A1")!Originally Posted by Norie
Try this.
By the way, where are you running this code? Access? Word? Another application?Please Login or Register to view this content.
If you are running the code in Excel why are you creating a new instance of Excel?
As for going against the message, you only get that message if you try and copy into a specific range.
Using one cell tells Excel you want to paste starting at that cell.
Please don't cross post, it wastes peoples time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks