title: Count transitions between '0' and '1' in a column with Excel VBA
body: <p>I have a column with '0' and '1' meaning that a machine is working(0) or not(1). I want to know the number of changes between '1' and '0' in order to know the working periods. 
  Example: </p>
  
  <p>0000000111110000000011111100000011111111111111111000000000( in column)</p>
  
  <p>The cicle will be having 0 change to 1 and change back to 0. 
  In the example there will be 3 cicles. </p>
  
  <p>Thank you in advanced. </p>