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