First I apologise. This is probably a stupid question.
I have been evaluating Spread 7.0 and looking at the custom name function.
I can use SetCustomName to define a custom name that points at a cell range, eg fpspread1.SetCustomName("Cell1", "A2");
I can use GetCustomName to get the cell range that the specified custom name is pointing to, eg fpspread1.GetCustomName("Cell1") returns "A2".
I can also iteratively use QueryCustomName to get all CustomNames in the workbook.
My question is how do I use CustomName to get the value(s) of the range defined by the CustomName, ie I want to get the contents of cell A2 using only the name "Cell1".
Thanks and regards
Nick