title: How can I prevent the VBA editor from removing internal whitespace?
body: <p>I find that aligning identifiers, operators, etc, in my code vastly improves readability. Mistakes just jump off the screen before I ever compile or run the code. However, the VBA editor deletes the extra spaces, destroying my alignment. For example, I try to type a few lines like this:</p>
  
  <pre><code>something         = "a" &amp; CStr(iRow1)  'Colm A = Something useful
  somethingElse     = "b" &amp; CStr(iRow1)  'Colm B = Something else
  dunno             = "c" &amp; CStr(iRow1)  'Colm C = Don't know what this is
  whatEver          = "d" &amp; CStr(iRow1)  'Colm D = whatever you want
  aVar              = "e" &amp; CStr(iRow1)  'Colm E = A variable
  xOrY              = "f" &amp; CStr(iRow1)  'Colm F = Might be X or Y
  aLongVariableName = "g" &amp; CStr(iRow1)  'Colm G = Long variable name
  </code></pre>
  
  <p>but what I get is this:</p>
  
  <pre><code>something = "a" &amp; CStr(iRow1)                      'Colm A = Something useful
  somethingElse = "b" &amp; CStr(iRow1)          'Colm B = Something else
  dunno = "c" &amp; CStr(iRow1)                                  'Colm C = Don't know what this is
  whatEver = "d" &amp; CStr(iRow1)                         'Colm D = whatever you want
  aVar = "e" &amp; CStr(iRow1)                            'Colm E = A variable
  xOrY = "f" &amp; CStr(iRow1)                            'Colm F = Might be X or Y
  aLongVariableName = "f" &amp; CStr(iRow1)  'Colm G = Long variable name
  </code></pre>
  
  <p>It is much less readable. Not even the comments are aligned. Note how easy it would be to spot a jRow among the iRow's in the first block compared to the second. And did you notice the error in the last row of the non-aligned code ("f" instead of "g")? Not that easy to spot without the alignment.</p>
  
  <p>So how can I prevent the VBA editor from screwing up my alignment by eating the extra spaces?</p>