Hi,
I want to write a code to select multiple sheets in my workbook but only if condition is met for most of them.
Example, I want that VBA selects first 3 sheets and for the rest of the 29 sheets only if cell value in I1 = YES; if value = NO, then not to select that sheet.
ThisWorkbook.Sheets(Array(MyArray)).Select
HOW TO DEFINE MyArray?
Sheets("CoverPage").Select
Sheets("MRAge").Select
Sheets("MROverall").Select
Sheets("MRD1").Activate
Dim strName As String
strName = "I1"
If strName = "YES" Then
Sheets("MRD1").Select
End If
Sheets MR I have from 1 to 29 and YES/NO should be applied for them.