Alan

Try
For each ce in range("a1:a5")
msgbox ce.address
next ce

This will loop through the cells a1 - a5 and show the
address.

Tony
-----Original Message-----
Hi Groups, I'd like to know if someone could show me how
to get the position
(col, row) of a cell in excel named range. What I need
to do is: I will
need to loop through a named range to find a particular
cell by value, once
I found it, I need to know the position of that cell.
I'm doing this with
C#, but any VB code would be help too. Thanks!.


.