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: 25
Default Area Between Two Cells

How ould I reference the cells between two certain cells. The number of
cells between the two cells change all the time.

Example....

A1: Quarterbacks
A2: BLAH
A3: BLAH
A4: BLAH
A5: BLAH
A6: Kickers

How would I reference only the cells between Quarterbacks and Kickers.
I need it to look for the name quarterbacks in a cell and go through
the cells until it reaches the name kickers in a cell.

 
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
Set print area over locked cells toolman Excel Worksheet Functions 0 October 17th 08 05:04 PM
DIVIDE BY A CELL TO AN AREA OF CELLS Debra Excel Worksheet Functions 1 March 22nd 06 07:38 PM
Area charts and blank cells Pat Charts and Charting in Excel 2 October 17th 05 06:52 PM
Sorting Area with Merged Cells prizm1 New Users to Excel 3 September 10th 05 11:49 PM
Select Cells in Print Area Chris Shaw Excel Programming 2 July 11th 05 03:34 PM


All times are GMT +1. The time now is 12:21 AM.

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

About Us

"It's about Microsoft Excel"