Simple Copy and Paste

I have a really simple issue that is screwing up and I don't know why. I am trying to copy cells A5:A100 on the first sheet and move them to a sheet called "BeerList". Here is the code I have used:

Range("A5:A100").Select
Selection.Copy
Sheets("BeerList").Activate
Range("A1").Select
Selection.Paste

I have tried to step through it but when it gets to Range("A1").Select it says "Runtime error 1004, Application-defined or object-defined error". Any idea what I am doing wrong?

Hi

I am bot sure why it does not work as for me copy and paste in excel does not always seem to function as it should, however try the following.

Please Login or Register  to view this content.

Regards


Jeff

Thanks a lot Jeff. That worked great. That's weird that copy and paste acts erratically sometimes. I will definitely just use this method in the future.