how do i select all cells in a worksheet
 

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!
--
Ken Smith

how do i select all cells in a worksheet
 

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
---------------
Jacob Skaria


"Ken" wrote:

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!
--
Ken Smith

how do i select all cells in a worksheet
 

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 Smith


"Ken" wrote:

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!
--
Ken Smith

how do i select all cells in a worksheet
 

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?
--
Ken Smith


"Ken" wrote:

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 Smith


"Ken" wrote:

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!
--
Ken Smith