Capture the Source Address of copied data
 

I am trying to develop code that reformats source and destination cells after
a copy/paste, cut/paste or drag/drop operation is performed by a user. I
understand how to use the Worksheet_change event to identify the destination
(target) cell, but I have been unable to figue out how to capture the address
of the source cell.

Has anyone figured this out?

Capture the Source Address of copied data
 

It seems to me that if you are copying a range, you would know where the
range is. If it is a selection, then it would be Selection.Address. All of
the other references would have to be either cells or range addressess, or
object variables that represent a range address. Just capture that address
in as a string variable before executing the copy. Then you can use the
string variable to come back to the copied range location.

"D Riggins" wrote:

I am trying to develop code that reformats source and destination cells after
a copy/paste, cut/paste or drag/drop operation is performed by a user. I
understand how to use the Worksheet_change event to identify the destination
(target) cell, but I have been unable to figue out how to capture the address
of the source cell.

Has anyone figured this out?