| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Up down arrow keys do not select cells if select locked cells unch | Excel Discussion (Misc queries) | |||
| Creating/Naming New Worksheets Based on Select Cells in Master Worksheet | Excel Worksheet Functions | |||
| How To Select Blank Cells within a worksheet | Excel Discussion (Misc queries) | |||
| need a macro select all cells in a worksheet? | Excel Discussion (Misc queries) | |||
| Want macro to select & copy cells from a different worksheet | Excel Discussion (Misc queries) | |||
![Ken[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
