Application.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: A formula or the name of the object, using the naming convention of Microsoft Excel. The length of the name must be less than or equal to 255 characters.

Dim strName As String: strName =  "SIN(45)"
Dim objEvaluate As Object
Set objEvaluate = Evaluate(Name:=strName)