title: Excel vba - multiple conditions and multiple statements
body: <p>I am very new to VBA coding and need some help. I'm looking for a code that selects ranges based on the value of differet cells.</p>
  
  <p>In my sheet i have 7 cells that have a formula which give the cell a "X" if i want an range is to be selected:</p>
  
  <p>If I33 = "X" then select A1: S31 (I33 has a formula)</p>
  
  <p>If I34 = "X" then select T1: AH31 (I33 has a formula)</p>
  
  <p>I have 7 of these ....</p>
  
  <p>What I'm looking for; if one or more of I33, I34, i35, I36, I37, I38 or I39 has an "X", the respective area (example A1:S31, there are 7 different ranges) should be selected. </p>
  
  <p>Thanks for any help :-)</p>