VBA – Group sheets based on their names

Sometimes you simply want to do an action in a file to all sheets, but not to the two important ones, named “Important1” and “Important2”. In this case, you may use a simple for/each loop with a select case option. In the current example, we will group all sheets in the excel file without the ones with the name “Imp1” and “Imp2”.

 

About

A VBA Developer.