Select Multiple Sheets Based on Cell Values VBA

Hello All,

I am new to Excel Forum and a relative novice to VBA. I appreciate any and all help!

I suspect this is easy, but what I am looking for is a code that will select multiple sheets if its corresponding value in a separate sheet is yes.

For example, in Sheet 4 I have a list starting in A1 going down that says Sheet 1, Sheet 2, Sheet 3. Starting in B1 going down the Values are "Yes", "No", "Yes". Therefore based on those values I would like Sheet 1 and Sheet 3 selected.

Thanks in advance!

Zach

Seems to work great! Thanks a lot. Really appreciate it!

Ok I apologize. There is one small issue. It selects the tab where the calculations are taking place. This is the "Calc" sheet in my workbook. This should never be selected. I tried adding that to the list of sheets the VBA code works through, but to no avail.

Any thoughts?

Thanks, sorry again.

Zach

I actually just moved it to a sheet that will always be selected and that solved the problem. Any idea why it selects cells C4 to N4 once complete? Not a big deal, just curious.

Thanks again!

I'm trying to use the code above, but I cannot get it to work, I don't have my list at a1, b1, I have my list in middle of sheet, so I put in C27:C38 for the Name of the sheets and D27:D38 is whether is yes or no. I cannot get any errors either? Help?? I've looked at several codes like this, but this one was simplified where I felt I could edit, the others I could get to run either. I must be doing something wrong????