Hi everyone,

I'm looking to copy a workbook sheet with around 150,000 rows to a new workbook which is blank. I seem to get the following error though:

The information cannot be pasted because the Copy area and the paste area are not the same size and shape. Try one of thge following:
  • Click a single cell, and then paste
  • select a rectablge thats the same size and shape and then paste


...

Is there an easier way to do this because it would take a good couple of minutes to select 150,000 rows in the new workbook.

Thanks

McKenzie