How to use the EVALUATE method
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)] |
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