WorksheetBase.Evaluate Method (Object)
Converts a Microsoft Office Excel name to an object or a value.
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
The following types of names in Excel can be used with this method:
Defined names. You can specify any name.
External references. You can use the ! operator to refer to a worksheet defined in another workbook.