a difficult problem
 

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 ***

a difficult problem
 

I am not sure , but I will take a guess

hit the = key
then go to the cell you want to reference, and hit enter


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=540899