This is the code I use . First I copyt the content which I want. And then run the macro below, but it pops out a error that class worksheet invalid paste method. Why is that?
Please Login or Register to view this content.
This is the code I use . First I copyt the content which I want. And then run the macro below, but it pops out a error that class worksheet invalid paste method. Why is that?
Please Login or Register to view this content.
Hi,
As there is no copy command, there is nothing to paste, that's why it fails. If you had already copied something before running the code, adding the new sheet would have cleared that.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks