How can I add a sheet to the selection in vba?

[ChrisMinder]

Hi everyone!

I'm a teacher and I use Excel for my school reports. My file contains 4 sheets for each students. The first and fourth page for each student are only printed once. The second and third pages are printed 4 times a year.

I'm trying to create a userform to select the sheets so I can then export them as a PDF. I'm fairly new to VBA.

Can someone tell me which command I can use to add a sheet to a sheets selection? If I only use Select, the sheet is selected but the previous selection is deselected.

Thanks for your help!

 

[Georgiboy]

Welcome to the forum,

You mean selecting multiple sheets as below:

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select

 

[ChrisMinder]

Yes but in my userform, I have a button for each sheet. I was hoping to find a way that clicking on this button would add this specific sheet to the already selected pages (by the other buttons).

Using your code would mean that I already know the selection but in my case, it will depend of the sheets I need to print.

 

[Alex Blakenburg]

I have logged off for the day but worksheet.select has a replace parameter, add false to the select statement and it will select the sheet without deselecting the already selected sheet. Eg

Sheets(1).Select False

 

[ChrisMinder]

Thanks Alex Blakenburg! That's exactly what I needed!