I have about 200 cells with names inserted using Insert Name
Define. When I click on a cell, the name shows in the box on the
Formula bar. Often, though, the name is too long for the Name box.

I've been trying to find a way to connect the ActiveCell with the
Workbook Names collection to get the cell name into a message box, but
I haven't found an easy method. It almost looks like I would have to
build a string from the cell's sheet name and row and column
reference, then cycle through the workbook names until I found a name
with a matching RefersTo.

Is it really that complicated? Or is there an easier way?

Ed