See Jerry's post about a helper row and sorting to reverse the cells.

Or reverse them in a helper row using

=INDEX($C$2:$F$2,4-(COLUMN(A2)-1))


Gord

On Wed, 14 Feb 2007 15:51:00 -0800, NWO wrote:

Ooppss...I meant to say c2:f2, and have the cell reference show as f2:c2 in
the function - is hti spossible?

"Gord Dibben" wrote:

B2:B7 is down a column not left to right.

What are the actual cells you wish selected right to left?

Maybe G2:B2?

What do you want done with those cells?

Excel by default will not look at a selection of cells from right to left.


Gord Dibben MS Excel MVP

On Wed, 14 Feb 2007 15:22:07 -0800, NWO wrote:

Hello.

I have a function that requires a string of cells, from the most current
month backwards, but when I attempt to select the values from right to left
(because this is the way the data is fixed on the source document), the
selection still shows the cell selection as left to right, so I have to copy
the data onto a separate sheet and manipulate the data so the function will
work properly.

Q - is there a way in Excel to select values from right to left so that the
reference indeed will read right to left, i.e. data in cell b2:b7 to read
b7:b2?

Thanks,
NWO