Hi,

I am trying to assign unique identities to the excel cell/range
objects. I searched around in the object definition of Range and found
that ID field was the only field where I could set my value. The
problem is once I set this ID on the cell or row object and then copy &
paste them, the ID's are copied as well. So I lose the identity and I
have duplicate rows.

Isn't there a UniqueID concept in Excel on the lines of Microsoft
project object (eg., task.UniqueID).

How can I uniquely identify a row/cell in the excel spread sheet.

your help in this regard is much appreciated.

regards