View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Fowler[_2_] Sam Fowler[_2_] is offline
external usenet poster
 
Posts: 8
Default Select rows after finding last cell

Hi

I have need to select all rows below the actice cell. I am able to locate the last cell with data and select the next cell.However, I need to select that row and all rows below that and make sure the row height is the same (12.75). I would like to select and resize the height of the rows all the way to the bottom, then import my data.

The The last cell (Active cell) when selected also changes depending on how much data has been copied into the worksheet

Thanks

Sam