| 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 |
| 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)
Threaded Mode
