Unique cell ID?

Prosenjit Banerjee · Mar 27th, 2002, 02:37 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.

Dave Hawley · Mar 27th, 2002, 02:55 AM

I am afraid naming the cell is the best option! To make the user unaware of this though (and prevent them changing it) just change the Name Visible Property to False.

Range("A1").Name = "MyCell"
ActiveWorkbook.Names("MyCell").Visible = False

They will never know!

Ian Mac · Mar 27th, 2002, 02:57 AM

Quote:

On 2002-03-27 01:37, Prosenjit Banerjee wrote:
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.

What is your Add In? Why would they need to install it twice?
Can Track changes not do the job? (baring in mind I don't know what the answers to qusetions 1 and 2 are)

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

Mar 27th, 2002, 02:37 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.

Mar 27th, 2002, 02:55 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	I am afraid naming the cell is the best option! To make the user unaware of this though (and prevent them changing it) just change the Name Visible Property to False. Range("A1").Name = "MyCell" ActiveWorkbook.Names("MyCell").Visible = False They will never know!