If I name cell E2 "MyCell", the following code returns the name:

Range("E2").Name.name

This only works if it is a single cell named range.

--JP

On Aug 13, 12:35*pm, Xavier wrote:
I have no problem in addressing cells with name, adding names to the list but
have not yet found the way to retreive the name of the active cells. If any
one has a clue, this would be very appriciated.