View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
D Riggins D Riggins is offline
external usenet poster
 
Posts: 7
Default 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?