Excel Vba Set Worksheet Focus. Not what you notice is that compared to acquiring the Worksheet by its VBA Name, when using the defaults Worksheets. You can use most Microsoft Excel worksheet functions in your Visual Basic statements.
VBA makes Excel's worksheet functions available through the WorksheetFunction object, which is contained in the Application object.
The following Sub procedure uses the Min worksheet function to determine the smallest value in a range of cells.
Once you set a worksheet reference to an object variable (using the SET statement), that object can be used instead of the worksheet reference. Sample macros and VBA settings for working with Excel worksheets. VBA Activate Worksheet method is used to makes the current sheet as active sheet.








