title: VBA - If a cell in column A is not blank the column B equals
body: <p>I'm looking for some code that will look at Column A and as long as the cell in Column A is not blank, then the corresponding cell in Column B will equal a specific value.</p>
  
  <p>So if Cell A1 &lt;> "" then Cell B1.Value = "MyText"
  And repeat until a cell in Column A is blank or empty.</p>
  
  <p>To add a little more clarification, I have looked through the various loop questions asked and answered here.  They were somewhat helpful.  However, I'm unclear on how to get the loop to go through Column A to verify that each cell in Column A isn't blank AND in the corresponding cell in Column B, add some text that I specify.</p>
  
  <p>Also, this will need to be part of a VBA macro and not part of a cell formula such as =IF</p>