LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 71
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vba - Select Used Range minus the top header Johnny[_11_] Excel Programming 5 April 21st 23 08:11 PM
Excel 2007 header sperky_ma Excel Discussion (Misc queries) 1 June 3rd 09 01:58 PM
How to select a range based on what's in the row header? Rachel Garrett Excel Programming 2 July 16th 08 08:47 PM
Excel - option to select the same header for mutliple tabs Sarah Beattie Setting up and Configuration of Excel 3 August 31st 06 04:20 PM
How can I select a range of cells for header? emil Excel Programming 2 June 11th 06 10:38 AM


All times are GMT +1. The time now is 11:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"