pasting problem

**shak1** · 07-02-2009, 03:30 AM

I have a command button that I want to automatically copy and paste certain data to another worksheet when clicked. I keep getting a "runtime error 1004; application-defined or object-defined error". The code I have so far is:

Please Login or Register  to view this content.

The line in bold, "Range("C36").Select" when I try and select the area to paste it, is where I am getting the error message. Any help is appreciated.

**DonkeyOte** · 07-02-2009, 05:03 AM

Perhaps:

Please Login or Register  to view this content.

or possibly

Please Login or Register  to view this content.

**rwgrietveld** · 07-02-2009, 05:09 AM

Would this single line help you

Please Login or Register  to view this content.

**shak1** · 07-02-2009, 05:23 AM

Thank you rwgrietveld that actually works (almost) perfect, ideally I would want it to 'Paste Special' 'Values only' so that it fits into the layout. Is there any way to do this with the line you just provided in your previous post?

Thanks,

Shak

**shak1** · 07-02-2009, 05:49 AM

Figured it out. Thanks very much DonkeyOte and rwgrietveld, much appreciated.

**mudraker** · 07-02-2009, 07:39 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save