Solved

Copy Sheet to another sheet not working

Posted on 2013-06-20
2
291 Views
Last Modified: 2013-06-20
I recorded a macro below but it does not work.  I get a run-time error 1004.  It is a simple copy one sheet to another.  I just can't figure out.

  Sheets("Prices").Select
   
Rows("3:1853").Select
    Selection.Copy
    Sheets("Compare").Select
   
    Range("A3").Select
    ActiveSheet.Paste
0
Comment
Question by:leezac
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 39263846
Are the worksheets really named Prices and Compare? That's a common cause of run-time error 1004.

You could also try this one-liner:
Sub Copytron()
Sheets("Prices").Rows("3:1853").Copy Sheets("Compare").Range("A3")
End Sub

Open in new window

0
 
LVL 81

Expert Comment

by:byundt
ID: 39263867
Another possible cause is if worksheet Compare is protected. If so, the run-time error 1004 should say something about protected cells.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question