title: Pasting formulas across workbooks
body: <p>So I have about 50 columns worth of formulas to paste over onto new workbooks on a regular basis. Pasting them one by one works, meaning all references are identically positioned when I paste them across.</p>
  
  <p>However, if I try to paste more than 1 column formula at a time, I get:</p>
  
  <blockquote>
    <p>The range you are pasting from contains formulas that cannot be pasted into this instance of Excel.</p>
  </blockquote>
  
  <p>I tried <a href="https://stackoverflow.com/questions/7662741/excel-batch-pasting-formulas">this</a> and a couple other links, any idea if this can be done without VBA?<br>
  If not, any idea how to write this in VBA? tyvm</p>