Worksheet.Evaluate (Excel)

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

The following types of names in Microsoft Excel can be used with this method:

Evaluate (Name)

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

Dim strName As String: strName = 
Dim objEvaluate As Object
Set objEvaluate = ActiveSheet.Evaluate(Name:=strName)