Print Multiple Sheets in a Specific Order

[LikeButtah]

I am using this code to print out multiple sheets but when I print it always starts with the first sheet and not the last which is what I want since my worksheets are the names of personnel in alphabetical order. So when I print I get the worksheets out of the order I want. I want the last name first so at the end of the printing the first name is on the top of the pile of pages. How do I change the code to print out the way I want? Thanks.

Private Sub CommandButton1_Click()

Application.ScreenUpdating = False
Sheets(Array("Adams", "Brooks", "Collins")).PrintOut

End Sub

 

[bensonsearch]

Hi,
maybe try

sheets("Adams").printout
sheets("Brooks").printout
sheets("Collins").printout

in the order you need them of course