title: VBA to find the greatest and lowest value but getting run time error
body: <p>I am using the max and min function in VBA to find the greatest and lowest value but I am getting an error</p>
  
  <pre><code>Greatest_Percent = WorksheetFunction.Max(ws.Range("L2:L"))
  Lowest_Percent = WorksheetFunction.Min(ws.Range("L2:L"))
  </code></pre>
  
  <p>Run Time Error
  Method 'Range' of object '_Worksheet' failed</p>