how do i select all cells in a worksheet

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I need to select rows in use on a sheet, copy them, and paste them into
another sheet in the workbook. I currently have about 165 sheets in the
workbook and need to consolidate the data on all the sheets onto a single
sheet. The sheets have a variable number of columns and rows. I need to
select all cells and paste them starting at the left-most column. Can anyone
please help!
 
When I follow the instructions and copy the macro and try to run it, I get a
functin not found for LastRow. As I doing something wrong?
 
OK, I found the function at the bottom of the document. So I copied it over,
ran the macro, and the function only copied over the first line of eah sheet.
So any help?
 
Back
Top