Activecell is the active cell of a selection, so if the selection is one
cell, it is also the selection.

You can work with that

Msgbox Activecell.Value

or get properties of it

Msgbox Activecell.Address

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"GoBobbyGo" wrote in message
...
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?