Dev wrote:
Sorry for not being clear.

This is what I am trying to do: I want to get the range of the
copied cell. Ex: If I am trying to copy cell A1 to cell B2 - I am
able to see cell B2 as a range in the sheetchange event - but I want
to know from which cell I copied (cell A1 in this example; the source
cell).
Yes but WHY? What are you ultimately trying to achieve?


"Paul Lautman" wrote:

Dev wrote:
I am trying to get copied range,

Ex: I have some hidden properties associated to one cell,and want to
copy it to another cell - but not sure how I can get copied cell
range... When I do copy paste event in sheet change event - it's
giving me pasted cell range, but not sure how to know from which
cell it's copied programatically. Is this doable?

Any help is really appreciated.

This is the second post that you have made and this time you are
making slightly (but only slightly) more sense.

The reason why no one helped on your first post is that you didn't
make any sense at all. We are a helpful bunch, but we are not mind
readers.

Have another go and try to explain exactly what you need to do and
we might have some hope of helping you.