Usa the
IXLSWorkbook.Names o
TXLSWorksheet.Names proprietà to return the Names collection.
Usa the
Add method to create a name e add it to the collection.
Usa the
FindByCell metodo per restituire il nome definito il cui intervallo di riferimento contiene una cella del foglio di lavoro
The Add method's RefersTo argument must be specified in A1-style notation, including dollar signs ($) where appropriate. For example, if cell A10 is selected on Sheet1 e you define a name by using the RefersTo argument '=sheet1!A1:B1', the new name actually refers to cells A10:B10 because you specified a relative reference). To specify an absolute reference, use '=sheet1!$A$1:$B$1'.
Usa Names[index], where index is the name index number o defined name, to return a single Name object