title: Align text to left and right in Excel?
body: <p>I have a workbook in which I need to align text (from cells) to the left and the to the right. I have this so far but I don't know how to proceed.</p>
  
  <pre><code>Sub M()
  
  ActiveSheet.PageSetup.CenterHeader = ActiveSheet.Range("A1") &amp; " " &amp; 
  ActiveSheet.Range("B1")
  
  End Sub
  </code></pre>
  
  <p>I want to know in general how to override the alignment for text in each part of the header but in this instance, I need to have text aligned to the left in both the right and left headers.</p>