title: Nested Loops in VBA Excel
body: <p>I have a need to create a list based on this data. I need it to render numbers 000000 through numbers 080808. Hoping to format the data like this...</p>
  
  <p>000000 - CHW EQUIPMENT RTU</p>
  
  <p>000001 - CHW EQUIPMENT CHILLER</p>
  
  <p>Etc. I need a list of all potential combinations of numbers, with the description of what that would be. Like:</p>
  
  <p>=concatenate(A1,C1,E1," - ",B1," ",D1," ",F1)</p>
  
  <p>Except looped through all possible combinations. Can someone help me come up with a loop that would do this? I'm not that familiar with Macros.</p>
  
  <pre><code>A   B               C   D               E   F
  00  CHW             00  Equipment       00  RTU
  01  HHW             01  SM Steel Pipe   01  Chiller
  02  Steam           02  LB Steel Pipe   02  Split System
  03  Med Gas         03  Copper          03  Pump
  04  UG/Soil         04  Cast Iron       04  Boiler
  05  Domestic Water  05  Plastic         05  Cooling Tower
  06  Compressed Air  06  Double-Wall     06  Air Compressor
  07  Natural Gas     07  Sheetmetal      07  Fan
  08  Refrigerant     08  Fixtures        08  Unit Vent
  </code></pre>