Worksheets Vba Function. Using the worksheet name. The following sub procedure uses the min worksheet function to determine the smallest value in a range of cells.
Using the worksheet name. How to use worksheet functions in vba to access an excel function in vba add application worksheetfunction in front of the function that you wish to call. The first is with the sheets object.
And you want to activate sheet 2.
The part number the user enters is assigned to the partnum variable. The next statement activates the prices worksheet just in case it s not already the active sheet. For example suppose you have a workbook with three worksheets sheet 1 sheet 2 sheet 3. It is very important to understand the concept of worksheets in vba because all the time we work with worksheets.
