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.

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.

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).

"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.

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.

I have some hidden data in my source cell (which was saved in custom document
properties). I want to get that data even in the destination cell (to the
cell that I pasted) - that can be acheived only if I know the source cell
range.

Is there a way to get the copied (source) cell range during copy and paste
operation?

"Paul Lautman" wrote:

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.