Skip to main content

Application.WorksheetFunction property

Table of contents
  1. Syntax
  2. Example

Returns the WorksheetFunction object. Read-only.



expression A variable that represents an Application object.


The following example displays the result of applying the Min worksheet function to the range A1:A10.

Set myRange = Worksheets("Sheet1").Range("A1:C10") 
answer = Application.WorksheetFunction.Min(myRange) 
MsgBox answer

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>