Required Integer. The one-based column coordinate to test
IXLSName
Required WideString. The worksheet name to test Required Integer. The one-based column coordinate to test
SheetName;
Required WideString. The worksheet name to test Required Integer. The one-based column coordinate to test
SheetName;
| Required Integer. The one-based row coordinate to test |
'=Input!$B$2:$D$4' |
| Required Integer. The one-based column coordinate to test |
This example finds the defined name that contains cell C3 on the Input worksheet |
| Workbook.Names.Add( |
'InputBlock' |
| '=Input!$B$2:$D$4' |
'Input' |
Assigned(Found)
Workbook.Names.Add('InputBlock', '=Input!$B$2:$D$4');
Found := Workbook.Names.FindByCell('Input', 3, 3);
if Assigned(Found) then
Workbook.Sheets[1].Cells[3, 3].Value := Found.Name;
Workbook.Sheets[