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