Unique cell ID?

Prosenjit Banerjee · Mar 21st, 2002, 02:51 AM

Can anybody please tell me how can I get a unique identification for a cell? Suppose, when my add-in is running I allow the user to define a particular cell (say A1). After saving the workbook he/she uninstalls my add-in. Next, the user moves that particular cell to another (say B1). Now, he/she again installs my add-in. Even this time I want to identify correctly that the defined cell is B1 and not A1. How can it be possible? Please help me.

Please don't tell me to Name the cell. Because the user can change the name easily. I want that the user of Excel would be absolutely unaware of that.

[ This Message was edited by: Prosenjit Banerjee on 2002-03-21 02:23 ]

Sbirro Cornuto · Mar 21st, 2002, 02:53 AM

Name the Cell...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 02:51 AM	#1
Prosenjit Banerjee New Member Join Date: Mar 2002 Location: India Posts: 19	Can anybody please tell me how can I get a unique identification for a cell? Suppose, when my add-in is running I allow the user to define a particular cell (say A1). After saving the workbook he/she uninstalls my add-in. Next, the user moves that particular cell to another (say B1). Now, he/she again installs my add-in. Even this time I want to identify correctly that the defined cell is B1 and not A1. How can it be possible? Please help me. Please don't tell me to Name the cell. Because the user can change the name easily. I want that the user of Excel would be absolutely unaware of that. [ This Message was edited by: Prosenjit Banerjee on 2002-03-21 02:23 ]

Mar 21st, 2002, 02:53 AM	#2
Sbirro Cornuto Board Regular Join Date: Mar 2002 Location: Little Italy Posts: 93	Name the Cell...