How to use the EVALUATE method
Author: Oscar Cronquist Article last updated on November 15, 2018
The Evaluate method converts an Excel name to an object or value.
The picture above demonstrates a macro that uses the Evaluate method to sum numbers in cell range B3:B10.
| Excel Name | Description |
| A1-style reference | Excel handles references as absolute references. |
| Range | The following characters are valid: Range (colon) Intersect (space) Union (comma) |
| Excel defined name | Any name. |
| External reference | You are allowed to refer to a cell in another workbook. |
| Chart object | Any chart object name. |
Excel Method Syntax
expression.Evaluate( Name )
Arguments
| Name | Required. The object name, data type: Variant. |
Comments
Square brackets are the same as using the Evaluate method with a string parameter, examples:
| Evaluate | Square brackets |
| Evaluate("D4").Value = 10 | [D4].Value = 10 |
| Evaluate("MATCH(1,{2,3,4,1},0)") | [MATCH(1,{2,3,4,1},0)] |
EVALUATE method examples
This extensive vba reference list provides detailed information including syntax, arguments, return values, and examples for Visual Basic for Applications.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form