Chart.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 Microsoft Excel.

[a1].Value = 25 
Evaluate("A1").Value = 25 
 
trigVariable = [SIN(45)] 
trigVariable = Evaluate("SIN(45)") 
 
Set firstCellInSheet = Workbooks("BOOK1.XLS").Sheets(4).[A1] 
Set firstCellInSheet = _ 
 Workbooks("BOOK1.XLS").Sheets(4).Evaluate("A1")