Very new to VBA and having trouble with a simple macro running in 2010 that copies and paste to another worksheet. Code as follows:
When I run CopyResults, the sheet is opened but I get a runtime error 1004 paste method of worksheet class failed, with the line 'ActiveSheet.Paste' highlighted.
Please Login or Register to view this content.
Does anyone know how I can solve this issue. Thanks
Last edited by JBeaucaire; 06-11-2014 at 08:35 AM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
Does this do any better?
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
hi richard83,
I guess the root of the problem the copied sheet block does not fit the available sheet space.
Example: if you select A1 and run your code the copied selection would cause error while pasting in any cell except A1 because it is larger than available space of the sheet.
JBeaucaire that doesnt seem to work. Thanks
What range of data are you trying to copy?
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks