View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Alok Alok is offline
external usenet poster
 
Posts: 318
Default Select all but header row???

You have already got so many options. Why not one more?

Sheet1.Cells.Resize(Sheet1.Rows.Count-1).Offset(1).Select


"Meltad" wrote:

Whats the macro code to select all cells except row 1????