📊 Free Workbooks: [ Ссылка ]
🥷Join Excel Ninja Pro: [ Ссылка ](2 Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: [ Ссылка ] (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: [ Ссылка ] (25% off with code ‘25OFF’)
🟡 Create Custom Installers: [ Ссылка ]
👋 Business Inquiries, Consulting, Comments, etc: [ Ссылка ]

свернуть