Hello, I am trying to select several sheets that correspond to some criteria in the VBA code, to print them all in once afterwards. This works if I put their name but I cannot solve when the names are in an array
1) that code work
arrayGuide = Array("sheet1", "sheet2", "sheet3
Sheets(arrayGuide).Selec
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=Tru
2) I would like to have the same by taking the name of the sheets to select from a table.
I've tried so many things that it would not be useful to paste my last finding here ;-

Thanks a lot for your time and help !