I want know address of copied cell and workbook name of copied cell.

for example, I work bellow.

$D$3 cell copy
and then, I select the $F$20.
and, press a button be made in sheet1

the result, i want to know the cell address.
the answer is $D$3





*** Sent via Developersdex http://www.developersdex.com ***