Stefi,
So you have one way, or

Debug.Print ECell.Address(False, False, xlR1C1, , Range("B4:D5").Cells(1))

NickHK

"Stefi" wrote in message
...
I found a solution:

ERNG.Row - ECELL.Row + 1
ERNG.Column - ECELL.Column + 1


Is this the best solution?

Stefi


"Stefi" ezt írta:

Hi All,

I have a For each cycle, like this:

For Each ecell In erng

Next ecell

I can't figure out how to determine row and column indices of ECELL
inside
the cycle. I mean that I'd like to know for example, that the current
ECELL
is in the 3rd row and 2nd column of ERNG.

Please help! Thanks,
Stefi

Hi Nick,

I tried this way as well (I supposed that Range("B4:D5") should be
substituted with my range ERNG) but it returned the string "RC", I couldn't
find out why.

Stefi


€žNickHK€� ezt Ã*rta:

Stefi,
So you have one way, or

Debug.Print ECell.Address(False, False, xlR1C1, , Range("B4:D5").Cells(1))

NickHK

"Stefi" wrote in message
...
I found a solution:

ERNG.Row - ECELL.Row + 1
ERNG.Column - ECELL.Column + 1


Is this the best solution?

Stefi


"Stefi" ezt Ã*rta:

Hi All,

I have a For each cycle, like this:

For Each ecell In erng

Next ecell

I can't figure out how to determine row and column indices of ECELL
inside
the cycle. I mean that I'd like to know for example, that the current
ECELL
is in the 3rd row and 2nd column of ERNG.

Please help! Thanks,
Stefi