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?

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