Excel Vba Worksheet Examples. Worksheets 1 visible false. Use worksheets index where index is the worksheet index number or name to return a single worksheet object.
Example 2 vba worksheets. Worksheets 1 visible false. To do this we can either select sheet 1 as shown above and then use the command to put a random value in the active sheet which is sheet 1.
Delete all blank rows in worksheet this example macro will delete all blank rows in a worksheet.
Sub mymacro range a1 application worksheetfunction textjoin true range a2 range a3 end sub. Using the code from excel macro examples. There is a total of 387 worksheet functions that you can use in vba. These are very simple yet useful and most used functions statements in excel vba.