How to get an index of cell number in selction range.

[mar_male]

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

 

[Dave Peterson]

You have a response to your post in .excel

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

 

[Guest]

selection(1).Select

If you want to retain all the cells selected and make the first cell the
activecell

Selection(1).Activate