Select 'used range' except header row in excel 2007

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
 
S

Stefi

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

--
Regards!
Stefi



„Anita†ezt írta:
 
A

Anita

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...
 
S

Stefi

You are welcome! Thanks for the feedback!

Clicking the YES button will be appreciated.


--
Regards!
Stefi



„Anita†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Exclude header row when copying autofilter results? (XL2003) 1
Fill Down to Last Value 3
Adjust code to run anywhere on sheet 3
Post my named ranges in column A 10
Set the Header Row 4
Code to add comments to selected cells within a selected range 30
VBA CreateNames (ignores last 5 rows?) 6

Top