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

[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 (VBA Code):
....................
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]

You want the first cell in the range? You can use .range("a1") of the range.
Here is a short example:

Sub TestRange()
Dim rng As Range
Set rng = Range("a1", "d10")
Debug.Print rng.Address
Debug.Print rng.Range("a1").Address
End Sub

In the Immediate window shows:
$A$1:$D$10
$A$1
Is that what you wanted?