title: How to implement Application.Caller in Public Function
body: <p>The below function takes the value in column F (currency ticker), and returns the function output (USD 20 dollar equivalent of input) in column H. </p>
  
  <p>The issue is that the equation is not updating the value in column F when I drag the equation down column H (starting from H2).  </p>
  
  <p>Example: H2 = Oanda(F2)<br>
  When I drag this down (say to F10), the equation gives me the output for Oanda(F2) regardless of what the value is for F3-F10. I need some help implementing the Application.Caller feature here. </p>
  
  <pre><code>Option Explicit
  
  Public Function Oanda(ConvertWhat As String)
  
  'References
  '   Microsoft XML, vs.0
  '   Microsoft Internet Controls
  '   Microsoft HTML Object Library
  
  Dim Conversion As String
  Conversion = ThisWorkbook.Sheets("Employee").Range("F" &amp; ActiveCell.Row).Value2
  
  Dim IE As New InternetExplorer
  'IE.Visible = True
  IE.Navigate "https://www.oanda.com/currency/converter?quote_currency=USD&amp;base_currency=" &amp; Conversion
  
  Do
      DoEvents
  Loop Until IE.ReadyState = ReadyState_Complete
  Dim Doc As HTMLDocument
  Set Doc = IE.Document
  Dim Ans As String
  Ans = Trim(Doc.getElementsByTagName("tbody")(2).innerText)
  Dim AnsExtract As Variant
  AnsExtract = Split(Ans, " ")
  
  Oanda = AnsExtract(4) * 20
  
  End Function
  </code></pre>