View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken[_6_] Ken[_6_] is offline
external usenet poster
 
Posts: 3
Default 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