title: Trying to create a range from a set of values
body: <p>So I have a range of cells that contains a list of Cell Addresses. </p>
  
  <p><img src="https://i.stack.imgur.com/c1Pbk.png" alt="enter image description here"></p>
  
  <p>Column B &amp; C show where a block of information starts and ends.  Column D states whether it is the start of a combination of tables, the end of the combination, or whether it's a single Table.  </p>
  
  <p>So basically I am having some difficulty combining the answers from B &amp; C to form a combined range.  So in the picture, Column E shows the start as A170 and the End as A596.  (I don't think this is necessary tbh) I need to make a range containing A170:A543, A548:A554, etc. and it needs to be dynamic.  So these should create themselves based on the values in Column D.  I'm looking to do this in VBA, but if it's easier to do in Excel Formulas, that's okay too.  </p>
  
  <p>Can anyone give me some hints how to accomplish this?  My brain is currently mush.</p>