Copy a worksheet using last row

[Scoobster_doo]

Hi Guys.

I'm looking to copy an entire worksheet starting from row 2 down to the calculated last row. I know the amount of columns i.e. from A to X all need copying in one.

Is there way to do it in one rather than each column?

At the moment I'm doing it column by column i.e.

Please Login or Register  to view this content.

which works, however I have a lot of columns!

Thanks

[Sintek]

Something like this perhaps:

Please Login or Register  to view this content.

[xlnitwit]

Hi,

Assuming that all columns have the same amount of rows, you can do this

Please Login or Register  to view this content.

[davesexcel]

Please Login or Register  to view this content.

"a" being just 1 cell

[DannyJ]

Please Login or Register  to view this content.

Then for the range you can do something along the lines of

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Scoobster_doo]

all perfect answers guys and a good variation of exactly what I wanted thank you.

I've +rep all given they were all correct

[DannyJ]

Thank you for the rep, glad we could all help!

[JOHN H. DAVIS]

Thanks for the rep and the feedback.

[Sintek]

Thanks for rep+