title: Trying To Get Max Number In A Range
body: <p><strong>Hi,</strong> I am trying to get the max number from a range. I have tied <strong>2 approaches to do this</strong>, one is working other is not but it should work. Below code is working for me, I can get max with this code.</p>
  <pre><code>Dim mymax As Range
      Set mymax = Range(&quot;b13&quot;).CurrentRegion
      Range(&quot;b11&quot;).Value = Excel.Application.WorksheetFunction.Max(mymax)
  </code></pre>
  <p>Now the code below this is not working, why it is not working? Technically it should work. Can you please let me why its not giving me max number?</p>
  <pre><code>Dim mymax As String
         mymax = Range(&quot;b13&quot;).CurrentRegion.Address
         Range(&quot;b11&quot;).Value = Excel.Application.WorksheetFunction.Max(mymax)
  </code></pre>
  <p>Thanks for your time and opinion.</p>