Excel VBA Tips n Tricks #3 Most powerful function in Excel Visual Basic - The EVALUATE Formula

📊 Free Workbooks: https://www.excelvbaisfun.com/links?utm_source=youtube&utm_medium=desc&utm_content=CdQJqT_9uf4 🥷Join Excel Ninja Pro: https://www.excelvbaisfun.com/ninjapro🔥(2 Months FREE On Annual Plan Auto Applied) 🥷Excel Ninjas FB Group: https://www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more) Using the Evaluate function, exclusive to Excel's VBA, you can easily use "Normal" functions and arguments, just like you would in a cell. Sometimes you don't want to or need to use the Range or Cells objects and want to keep it simple, especially if you will always have the correct sheet selected for this example. Here are two of the syntaxes answer = [a1 - a2] [a1] = "Hello World!" answer = Evaluate("=A1 - A2") Stop Fantastic Developer Tools: 🔒 Transform Any Excel File Into A Locked EXE: https://www.excelvbaisfun.com/secure-excel-files (25% off with code ‘25OFF’) 🟡 Create Custom Installers: https://www.excelvbaisfun.com/custom-installers 👋 Business Inquiries, Consulting, Comments, etc: https://www.excelvbaisfun.com/contact/