how do i select all cells in a worksheet

[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!

 

[Jacob Skaria]

Check out the below link by Ron for topic "Copy from row 2 till the last row
with data"

http://www.rondebruin.nl/copy2.htm

If this post helps click Yes

 

[Ken]

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?

 

[Ken]

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?