Excel Tricks 022 - How to use "Evaluate" and "WorksheetFunction" in VBA?
Very often, in writing VBA, we have to borrow some built-in functions in Excel Worksheet. For example, "proper", "weeknum", and most importantly "vlookup". This video tells you how....