How to Select Multiple Worksheets in Excel VBA Posted on October 29, 2021October 29, 2021 by Summa Lai Sometimes, you may want to select a group of worksheets in Excel. Below is the way how to do this. Sheets(Array(“sheetname1”, “Sheetname2”, etc…) Below, please see a sample.