RETURN SELECTED CELL NAME FORMULA

[ndendrinos]

Is there a formula that will return in A1 the selected cell name in range B1:B10
example : If I click in B2 I will read in A1 the word "B2"

Easy to do with a message box but a formula?
I do not want the user to have to accept macros when he or she opens the file

Thank you

Edit: If easier I could type in the cells their name and have the formula in A1 return the selected cell's "VALUE"

example In B1 I would type B1 etc...

 

[ndendrinos]

Bonsoir Erik,
Not sure if your note is addressed to me but I thank you for it.
I will assume then that you agree there is no formula that will do the same thing
Thank you

 

[erik.van.geit]

indeed for you

formulas cannot catch events: retrieving the address of a SELECTED cell is an event

bonsoir

in Belgium there are 3 languages:
- dutch (flemmish)
- french (wallon)
- german (really little part)

I'm dutch-speaking.

tot volgende keer, :wink:
Erik