leezac
asked on
Copy Sheet to another sheet not working
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
Sheets("Prices").Select
Rows("3:1853").Select
Selection.Copy
Sheets("Compare").Select
Range("A3").Select
ActiveSheet.Paste
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Another possible cause is if worksheet Compare is protected. If so, the run-time error 1004 should say something about protected cells.