Get address of cell clicked
Terry,
Look at Application.InputBox (with a Type of 8) in Help.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Terry" wrote in message
...
I want to write a macro that documents the address of the
cell that is clicked, NOT the active cell.
Example:
With A5 active, you invoke the macro.
The macro asks "What cell do you want to document?"
The user then clicks, say, A1.
The macro then enters this in A5: =cell("address",a1)&cell
("filename",a1)
Thanks!
|