How do I find out which cell I've selected?

I have a VBA routine that selects a (one-cell) named range, which will
likely move around due to row/column insertions and deletions.

How can I get VBA to know what actual cell it's in?