Excel VBA Evaluate Function - How to Use this Secret Function

Learn the Excel VBA Evaluate function. This secret function will separate you from other Excel VBA users who are not aware of it.

The Evaluate function can be used to simplify the writing of worksheet formulas in macros, and also the referencing of objects.

This video will show you how this is done, explain the benefits, and show you a cool shorthand use of the function.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[EricHartwigExcelConsulting]

Seriously awesome video! Thank you creating/sharing this!
I have been using the Evaluate function to populate an array with a dynamic named range on a worksheet and it saves so much extra code.

[kurttruk]

using [ ] in place of the range object does increase your processing overhead a little. So I would not generally use it unless my code was having a SERIOUS problem in readability.
Where evaluate comes into it's own in creating a formula from string variables. This is has given me SO MUCH flexibility in my User Defined Formulas

[limichael]

This is a very useful video to understand Evaluate Function in VBA. Thanks for sharing. And love ur British accent btw

[posfr]

Brilliant. Best thing since sliced bread!

[arminpiruz]

Very very nice explaining .. thank you

[pratikjain]

Great Video. Could you also do an example with more complex formulas like INDEX-MATCH? But really good information. Thanks!

[semperdiscendum]

That was awesome!! Thank you so much!!

[Karthickchidambaram]

Thank you So much... You saved my time :)

[scotolivera]

Loved the [sum(a:a)] this is the one that separate you from the crowd 😃

[TheLonelymusic]

How to evaluate vlookup formula ie to get only the result of VBA formula into the cell. I tried this but getting error kindly assist

[zvit]

When you evaluate A, How does the Evaluate function know which sheet to evaluate? In most of your examples, it does not specify which sheet.