Worksheet.Evaluate Method

Converts a Microsoft Office Excel name to an object or a value.

Namespace:  Microsoft.Office.Tools.Excel
Assemblies:   Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Function Evaluate ( _
    Name As Object _
) As Object
Object Evaluate(
    Object Name
)

Parameters

  • Name
    Type: System.Object

    The name of the object, using the naming convention of Excel.

Return Value

Type: System.Object

Remarks

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.

.NET Framework Security

See Also

Reference

Worksheet Interface

Microsoft.Office.Tools.Excel Namespace