I have a workbook in which I need to select multiple sheets using VBA. The start sheet always has the same name and the end sheet always has the same name. However, there could be from 1 to 12 sheets in between with varying names (as well as some sheets after the end sheet or before the start sheet).
How can I select all the sheets in between start and end (including start and end) no matter how many are in the middle?
Thanks.
How can I select all the sheets in between start and end (including start and end) no matter how many are in the middle?
Thanks.