title: VBA Repeat Character Or Number in Array
body: <p>I need to repeat two characters(Y,N) 2^a number of times infinitely along a column in excel. So in the first column each character will repeat 2^0 = 1 and look like this:</p>
  
  <pre><code>Y
  N
  Y
  N
  </code></pre>
  
  <p>The second column repeats infinitely 2^1 =2 times</p>
  
  <pre><code>Y
  Y
  N
  N
  Y
  Y
  N
  N 
  </code></pre>
  
  <p>and so on- I need to do this for 24 columns! Is there a simple way to do this? I think it may have to use an array formula...</p>