Going from what you specify in your other post (which should have been a reply in this thread instead of a new thread):
In a particular cell (c20, for instance), I want that cell to always display the address (row and column) of the current cell that I have clicked on. Thus, cell c20 would display whatever location is shown in the upper left hand reference area.
Actually, that particular formula won't work at all for the question at hand. Well, it *will* work for returning the address of the cell it is entered in (which is what the OP seemed to be asking at first), but not for the address of the cell that is selected (as the OP specified in the post I linked to this thread).