How does Excel references a cell?

  • Thread starter Thread starter Vitaly
  • Start date Start date
V

Vitaly

Hi all,

I'm using a windows forms control that is very similar to Excel, but it's
written completely in managed code.

What I need to do is to reference a cell from outside the control. I need to
uniquely identify a cell. I see one approach now - using named ranges. So the
reference to a cell will be composed of a workbook file name and a named
cell. But if a user modify "the name of the named cell" the approach will not
work.

So, I'm wondering how does Excel references a cells, keeping in mind, that
the referenced cell can still be moved and the link should not be broken.

Thanks,
Vitaly
 
Programmatically you can hide the name, that would prevent most users from
seeing and changing it. Another way would be with a simple cell formula on
an xlVeryHidden sheet, eg =Sheet1!A13. I can't think of any other way to
"track" a cell.

Note with either method, if the row or column containing the referenced cell
is deleted you will get a #REF! error

Regards,
Peter T
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make a maro run upon leaving a cell 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Named Range maker code 9
How to reference a cell from anther workbook without opening it 0
Enter data in cell referenced in a cell 4
Worksheet Cell Reference 1
Reference sheets named by DAY 7
How to get notified when user inserts cells, rows, or columns in W 4

Back
Top