I have the following problem - I often have to copy a range, then paste in a
bunch of places, and then go back to the copied range and make changes. And
since it is often in different worksheets and a lot of scrolling is
involved, it is a very time-consuming process that i would like to automate.

Is there anyway, programmatically, to determine the Address of the copied
range? Or, alternatively, is there some OnCopy event that I can trap and
use to determine the copied range? Ideally, I would like to have a button
or shortcut key that would always bring me back to the site of last copy.

I already have an implementation that would work, if only I was able to
track the event... Is this possible?

Any help would be appreciated.