Select Worksheet With Vba. Select multiple worksheets using Excel Worksheet. When we have multiple worksheets in a workbook, we can select required sheet using VBA.
Activate ' Do something here newWS. Activate. expression A variable that represents a Workbook object. Sub printformat() Dim shCount As Integer ThisWorkbook.
Select multiple worksheets using Excel Worksheet.
Activate ' Do something here newWS.
The following line of VBA code selects a single worksheet. But if you really want to use VBA to physically select multiple worksheet, you can use Worksheet. VBA Code To Select Next Sheet: The Select method in VBA can be just as time consuming for Excel, as it is for you to get up off the couch to change the channel.