How to get a cell ref when selected?
Posted by Daniel on November 15, 2001 1:08 PM
It seams like a simple thing to me...
What I want to be able to do is, when one clicks on a cell, the address of that cell will be returned to another cell. Then I would be able to use the returned cells address for a VLOOKUP table.
The closest thing I can find is =ADDRESS but it only works after the cell contents have been changed wich is after the fact for me. I would appreciate a clue on this one. - Thanks