Capture the Source Address of copied data

  • Thread starter Thread starter D Riggins
  • Start date Start date
D

D Riggins

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.
 
Back
Top