Copy Data from sheet to sheet using VBA

[koticphreak]

Hey Everyone, I've looked at a few different posts about copying and pasting data and not sure what I'm doing wrong. I'm trying to select everything from one sheet and copy it to another sheet starting in cell B2. Please tell me where I'm going wrong:

Please Login or Register  to view this content.

[David A Coop]

Try something like this:

Please Login or Register  to view this content.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[jindon]

Paste method applies to worksheet object, so Selection should be ActiveSheet

Please Login or Register  to view this content.

However this one line should be enough...

Please Login or Register  to view this content.

[koticphreak]

Try something like this:

Please Login or Register  to view this content.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

When I try this, I get 1004, "Select method of Range class failed" and when I debug, it points to Range("A1:B1006").Select

[john55]

or

Please Login or Register  to view this content.