As part of a project I have been working on, a user will need to print between 5 and 50 worksheets. To automate the printing I need to programmatically select the sheets before printing. (I imagine that the user will click a button, and the sheets will be selected by grouping and then printed without any other user intervention.)
I do not know all the sheet names or the total count of them but they will always start with 'Work Sheet...' or 'Results Sheet...' (eg "Work Sheet", "Work Sheet (2)", "Work Sheet (3)", etc. or "Results Sheet", "Results Sheet (1)", "Results Sheet (2)", etc.).
Is it possible to use a wildcard in VBA to select the sheets so that they can be printed? If so, any suggestions on some code to do that?