i have this to print specific worksheet using command button but i want to it can be set what pages will be printed base on cell data
Sub printsheet()
Dim ws As Worksheet, wks As Worksheet
Set wks = Worksheets("Main")
Select Case wks.Range("A1").Value
Case 1...