title: Cannot Run Visual Basic Editor Because of a Syntax error whilst recording macro
body: <p>I am a bit suprised as I am trying to <strong>record</strong> a macro in Excel, but I keep getting this error:</p>
  
  <pre><code>Cannot Run Visual Basic Editor Because of a Syntax error
  </code></pre>
  
  <p>The most surprising part is that I am not trying to run any macro yet, just trying to record it. </p>
  
  <p>The first time I noticed this I tried to record something like </p>
  
  <pre><code>vlookup(Today(),Sheet2!A1:B2,2)
  </code></pre>
  
  <p>Initially I assumed it was an error in the formula I typed, but then I noticed that the correct value was displayed in the sheet. </p>
  
  <p>Now I have a module that looks like this, and each time I try to record something the error pops up.</p>
  
  <pre><code>Option Explicit
  Sub Macro34()
      ActiveCell.FormulaR1C1 = "=TODAY()"
  End Sub
  Sub Macro35()
      ActiveCell.FormulaR1C1 = "=5"
  End Sub
  </code></pre>
  
  <p>I have written some other macro code in other modules, but that is not supposed to run at the moment (and I didn't see any errors in it as well).</p>
  
  <hr>
  
  <p>I have searched for this error but each found result is about someone trying to run a macro. It is really annoying me so I hope someone can tell me how to get rid of this error.</p>