Cutting and Paste Excel Range from Sheet1 to Sheet2, doesn't

hi,

i'm working on creating excel com add-in.

for add-in, have created range com object in sheet1.

whenever user insert or delete rows , columns, range.address modified automatically.
whenever user renames sheet, range.parent.name reflects renamed sheet.
whenever user cuts , paste range in sheet1, range.address reflects modified/moved address.

but when user cuts , paste range sheet1 sheet2, range.parent not reflected i.e. range.parent.name sheet1 (not sheet2) address reflects.

range.worksheet behaves same way.

is there way identify

regards,

sivanesan.s

moved from: office / excel / windows 10 / office 2016

no.

the reason range object not standalone object (like shape), refers (a part of) existing cells.

and have problem: if user deletes cells (usually user deletes rows) refer to, range object becomes invalid.

andreas.

Office / Excel / Microsoft Office Programming / Office 2016

Cororate