title: Excel WorksheetFunction.Trend function in VBA
body: <p>I have the formula =TREND({4000,20000},{0,32},B15) in an Excel cell.</p>
  
  <p>What is the correct way to use this in a VBA function? </p>
  
  <p>I keep getting Runtime Error 1004: Unable to get the Trend property of the WorksheetFunction class, whenever Itry variations along the lines of:</p>
  
  <p>WorksheetFunction.Trend("{4000,20000}", "{0,32}", "B15")</p>
  
  <p>Thanks.</p>