Pallavi

You have to use the name property twice:

Target.Name.Name

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Pallavi Singh" skrev i en meddelelse
...
Hello,
Could anyone point out how to get a cell's name in the VBA code.
I am trying to retrieve a cell's name - for example suppose target is
the range object pointing to a single cell.
Following lines get the cell address instead of cell name.
target.Name or target.Cells(1, 1).Name
How do I get the cell's name instead of address?
Thanks in advance