First row in Selection range (first index of a cell)

[Marcin]

Hello,
I have a problem with selecting first cel in selection Range or return
an index of the first cell in Selection Cell.

I have something like this:
....................
Range1.Select
"and here I want to Select the first range in selection Range1"
.............
I there any special function of finding first cell in selection range
or returning an index of the first cell??
Thanks for answet
Marcin

 

[Tony Jollans]

The first cell in the selection can be got with ...

selection.cells(1)

or

selection.range.cells(1)

Its row and/or column nuber can be got with the RowIndex and/or ColumnIndex
properties

BUT beware that, depending on the selection, the cells in Selection and
those in Selection.Range may not be the same (although the first - and
last - ones will be)

 

[Marcin]

Thanks for answer,
Could You tell me how will the statement with RowIndex look like?
selection.cells(1).RowIndex?

 

[Tony Jollans]

Yes! Go on, give it a try!