Run-time error 1004 paste method of worksheet class failed

**Castillb** · 05-03-2013, 06:56 PM

I'm trying to run a macro but I'm getting the following error message:

Run-time error 1004 paste method of worksheet class failed

When I click debug on the error message window ActiveSheet.Paste is highlighted yellow. Can someone tell me what I may be doing wrong?

Please Login or Register  to view this content.

**Martijnvc** · 05-03-2013, 07:18 PM

What are you trying to achieve? What are you copying and pasting? Some more code or workbook would be useful, hard to tell from this

**jolivanes** · 05-04-2013, 01:51 AM

Like Martijn said, more code would certainly help

You don't need (and want) to select when copying/pasting.

Please Login or Register  to view this content.

will copy range A1:A5 of the active (visible) sheet and paste it in cell B1 (B1:B5) of the active sheet.

If you want to paste from the active sheet into a different (non active) sheet, you can use

Please Login or Register  to view this content.

There are multiple ways to accomplish this but more info is required

**Castillb** · 05-04-2013, 11:51 AM

Martin & Jolivanes -

At the end of every month there is a report that I run off of MS Access, which I export to Excel. Once the data is in Excel, there is all sorts of formatting that I perform in order to make it more presentable for the viewer. My goal is to create a macro that will perform
all of the formatting. The script I have included below is achieving most of it, but I get an error message near the end of the script where it reads

ActiveSheet.Paste (not the 1st one from the bottom, but the 2nd one)

Please Login or Register  to view this content.

**tehneXus** · 05-04-2013, 12:10 PM

try this, I had to remove some pasting into A1, O1 because it wasn't clear what should be pasted:

Please Login or Register  to view this content.

**jolivanes** · 05-04-2013, 04:18 PM

And this

Please Login or Register  to view this content.

can be replaced by this

Please Login or Register  to view this content.

**Castillb** · 05-06-2013, 11:13 AM

TehneXus,

That worked perfectly. Thank you so much!

Originally Posted by tehneXus

try this, I had to remove some pasting into A1, O1 because it wasn't clear what should be pasted:

Please Login or Register  to view this content.

**hatzisn** · 08-12-2013, 01:33 PM

Hi all,

I am having the same problem. My paste method fails. I run my code in MS Excel 2010 and it fails
while the same time if I run it on MS Excel 2003 it works perfectly. Can anyone help? Here is my code:

Thanks in advance

Please Login or Register  to view this content.

**jolivanes** · 08-12-2013, 02:04 PM

hatzisn
Please read the forum rules. In this case, #2 is of interest to you.

http://www.excelforum.com/forum-rule...rum-rules.html

**hatzisn** · 08-12-2013, 02:24 PM

Thank you jolivanes. I did not know that. I will keep that in mind.

Run-time error 1004 paste method of worksheet class failed

LinkBack

Thread Tools

Rate This Thread

Display

Run-time error 1004 paste method of worksheet class failed

Re: Run-time error 1004 paste method of worksheet class failed

Re: Run-time error 1004 paste method of worksheet class failed

Re: Run-time error 1004 paste method of worksheet class failed

Re: Run-time error 1004 paste method of worksheet class failed

Re: Run-time error 1004 paste method of worksheet class failed

Re: Run-time error 1004 paste method of worksheet class failed

Re: Run-time error 1004 paste method of worksheet class failed

Re: Run-time error 1004 paste method of worksheet class failed

Re: Run-time error 1004 paste method of worksheet class failed

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions