<div>
Another possible cause is if worksheet Compare is protected. If so, the run-time error 1004 should say something about protected cells.
</div>


Another possible cause is if worksheet Compare is protected. If so, the run-time error 1004 should say something about protected cells.

<div>
<div class="content wysiwyg-content">
I recorded a macro below but it does not work. &nbsp;I get a run-time error 1004. &nbsp;It is a simple copy one sheet to another. &nbsp;I just can't figure out.<br />
<br />
&nbsp; Sheets(&quot;Prices&quot;).Select<br />
&nbsp; &nbsp;<br />
Rows(&quot;3:1853&quot;).Select<br />
&nbsp; &nbsp; Selection.Copy<br />
&nbsp; &nbsp; Sheets(&quot;Compare&quot;).Select<br />
&nbsp; &nbsp;<br />
&nbsp; &nbsp; Range(&quot;A3&quot;).Select<br />
&nbsp; &nbsp; ActiveSheet.Paste
</div>
</div>


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

Copy Sheet to another sheet not working

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.