Perfect. Thanks to all who answered with the "offset" solution.

"Bob Phillips" wrote:

Define Front as

=OFFSET($1:$1,0,$A$10-1,1,7)

where A10 is the cell with the value

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"fedude" wrote in message
...
What I have is a row of numbers that contain 2 named ranges (Front and
Back).
Both ranges are 7 columns wide and 1 row deep. What I want to do is
change
the location of the ranges based upon another cell.

For instance, here are the numbers (each in it's own column):
5,2,7,4,1,6,3,8,9,5,2,7,4,1,6,3,8,9,5,2,7,4,1,6,3, 8,9

The ranges are each 7 columns wide and are offset by the value in another
cell:
For instance if the cell contains 5, the range "Front" would be
1,6,3,8,9,5,2

Can someone point me in the right direction?