indices in named range
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
|