title: How do I concatenate multiple cells using structured references for excel tables in vba code
body: <p>I am trying to concatenate multiple columns and separate each by a "-". When ever I run the below code, it gives me a type mismatch error. How can I make the types align or at least allow the cells concatenate ?</p>
  
  <p>The concatenate works whenever I remove the hyphen(-) but once I put it or any other value not a column it fails. Please help, I can't seem to clear this error. Can I get help making it concatenate with the (-)? I have tried removing the range. I have tried range.Value instead of range.formula and it still does not work</p>
  
  <pre><code>Range("Table2[New_app]").Formula = "=iferror(vlookup(Input2!$Q2,AppRef,3,false),0)" 'This is a previous line of code that works 
  
  'This is the code that is not working 
  Range("Table2[[MIS-MONTH]]").Formula = "=CONCATENATE(Table2[New_Name], " - ", Table2[Month])"
  </code></pre>
  
  <p>the result should be something like this: </p>
  
  <pre><code>Column1content-Column2content-Column3content
  </code></pre>
  
  <p>However I keep getting run time error '13'  Type Mismatch</p>