Select 'used range' except header row in excel 2007
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 |
Select 'used range' except header row in excel 2007
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 |
Select 'used range' except header row in excel 2007
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 |
Select 'used range' except header row in excel 2007
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 |
All times are GMT +1. The time now is 08:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com