I want to display the named range in a userform when I click on a cell. If a name doesn't exist it should just display the address.

This works if the range is name.

Please Login or Register  to view this content.
but if it is not I get a Run Time Error '1004' message.
Some of my named ranges are merge cells and some are not but that doesn't seem to be the issue.

Any suggestions?