identify defined names in VBA code

Using Excel 2003 VBA, I couldn't find a possibility to find out the defined name of a selected range, especially when I don't know that range as in a Worksheet_Change macro, so I created the below function.

Does anybody know an easier way to do this without having to use the .ListNames command which will write the names and references into a spread sheet?

Any help will be welcome!

Mike

Please Login or Register  to view this content.

They teach good manners in germany apparently.

Thanks, SuitedAces, this is great help!

I wonder how someone finds out such syntax. I could not find Target.Name.Name in VBA Help.
Of course, I stumbled across Target.Name, but this only gives me "=Sheet1!$A$1".

You made my day!

Mike