How to: Refer to More Than One Sheet
Use the Array function to identify a group of sheets. The following example selects three sheets in the active workbook.
Sub Several()
Worksheets(Array("Sheet1", "Sheet2", "Sheet4")).Select
End Sub
Ce navigateur n’est plus pris en charge.
Effectuez une mise à niveau vers Microsoft Edge pour tirer parti des dernières fonctionnalités, des mises à jour de sécurité et du support technique.
Use the Array function to identify a group of sheets. The following example selects three sheets in the active workbook.
Sub Several()
Worksheets(Array("Sheet1", "Sheet2", "Sheet4")).Select
End Sub