Select 'used range' except header row in excel 2007
in [Programming]
|
From: Anita on 29 Mar 2010 08:33 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
From: Stefi on 29 Mar 2010 08:45 Range("A1").CurrentRegion.Offset(1).Resize(Range("A1").CurrentRegion.Rows.Count - 1).Select -- Regards! Stefi „Anita” ezt írta: > 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
From: Anita on 29 Mar 2010 09:10 Perfect thanks! "Stefi" wrote: > Range("A1").CurrentRegion.Offset(1).Resize(Range("A1").CurrentRegion.Rows.Count - 1).Select > > -- > Regards! > Stefi > > > > „Anita” ezt írta: > > > 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
From: Stefi on 29 Mar 2010 09:13 You are welcome! Thanks for the feedback! Clicking the YES button will be appreciated. -- Regards! Stefi „Anita” ezt írta: > Perfect thanks! > > "Stefi" wrote: > > > Range("A1").CurrentRegion.Offset(1).Resize(Range("A1").CurrentRegion.Rows.Count - 1).Select > > > > -- > > Regards! > > Stefi > > > > > > > > „Anita” ezt írta: > > > > > 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
|
Pages: 1 Prev: Disable share workbook option in VBA Next: DoubleClick to return SeriesIndex & PointIndex |