Or simpler

Selection.Areas(3)(1).Value

Alan Beban

Zone wrote:
Jake, since you have selected three individual cells in a
non-contiguous selection, Excel sees them as three areas. Try
selection.areas(3).cells(1)
James
Jakobshavn Isbrae wrote:
I am trying to get to a certain place in a range, for example the 3rd item.
If the range consists of three cells A1, A10, A20 and I use
Number = 3
s = Selection(Number).Address
v = Selection(Number).Value
then I get to cell A3 (third from the start) instead of A20 (which is what I
want)

Can I get to a certain place without using a loop?
Thanks in advance


--
jake