Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does Excel references a cell?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does Excel references a cell?
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 "Vitaly" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute Cell References in Excel | Excel Discussion (Misc queries) | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
how do i sum if in two different cell references - Excel | Excel Worksheet Functions | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Excel Cell References are different to normal | Excel Worksheet Functions |