_Worksheet.Evaluate Method
Converts a Microsoft Excel name to an object or a value.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Evaluate ( _
Name As Object _
) As Object
'Usage
Dim instance As _Worksheet
Dim Name As Object
Dim returnValue As Object
returnValue = instance.Evaluate(Name)
Object Evaluate(
Object Name
)
Parameters
Name
Type: System.ObjectRequired String. The name of the object, using the naming convention of Microsoft Excel.
Return Value
Type: System.Object
Remarks
The following types of names in Microsoft 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.