Run-time Error '1004' Copy and Paste area aren't the same size

**PleaseHelpMe3** · 01-26-2016, 11:24 AM

I'm getting a Run-time Error '1004' Copy and Paste area aren't the same size. I'm not sure what I'm doing wrong though. The error is popping up on the "ActiveSheet.Paste" line. My code is below.

Thanks!

Worksheets("Levels").Select
Columns("B:K").Select
Selection.Copy
Worksheets("Summary").Select
Range("C4:L4", Range("C4:L4").End(xlDown)).Select
ActiveSheet.Paste

**Norie** · 01-26-2016, 11:31 AM

This isn't the cause of the error but you can't copy and paste entire columns unless you paste to row 1.

What are you actually trying to copy and where do you want to paste it to?

PS Can you add code tags when posting code?

Run-time Error '1004' Copy and Paste area aren't the same size

LinkBack

Thread Tools

Rate This Thread

Display

Run-time Error '1004' Copy and Paste area aren't the same size

Re: Run-time Error '1004' Copy and Paste area aren't the same size

Thread Information

Users Browsing this Thread

Similar Threads

Run-time error 1004 - Paste special

When Activesheet.paste, Run-Time error '1004': Paste method of work sheet class failed.

Error 1004 - We can't paste because the Copy area and the paste area aren't the same size

Run time error 1004 on picture copy and paste - excel 2010

Excel Macro Error - Run time error 1004 - Paste method of worksheet class failed

RTE 104 Copy and Paste area not the same size

Excel 2007 : Print Area macro giving me 'Run-time error 1004'

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions