Select 'used range' except header row in excel 2007

  • Thread starter Thread starter Anita
  • Start date Start date
A

Anita

Hello

How can I use code to select populated cells in a worksheet but exclude the
top row which is my header row? The spreadsheet has formulae down to about
row 2000 but all 2000 rows aren't always used... thanks
 
Range("A1").CurrentRegion.Offset(1).Resize(Range("A1").CurrentRegion.Rows.Count - 1).Select

--
Regards!
Stefi



„Anita†ezt írta:
 
Perfect thanks!

Stefi said:
Range("A1").CurrentRegion.Offset(1).Resize(Range("A1").CurrentRegion.Rows.Count - 1).Select

--
Regards!
Stefi



„Anita†ezt írta:
Click to expand...
 
You are welcome! Thanks for the feedback!

Clicking the YES button will be appreciated.


--
Regards!
Stefi



„Anita†ezt írta:
 
Back
Top