title: How to increment a character variable in a loop ~ VBA
body: <p>I need to make a loop to print a step like structure in an excel spreadsheet using VBA. </p>
  
  <p>I have to begin from the cell E1 and go till the number entered by the user in a text box. I need to print a string in the cells E1,F2,G3...and so on.</p>
  
  <p>I used the following but it did not work:</p>
  
  <pre><code>Dim j As Integer, N As Integer
  Dim i As String
  
  N = InputBox("Plese enter the number of Processes", "Enter data", "Enter number here")
  
  i = "E"
  
  For j = 1 To N
      Range(i &amp; j).Value = "Random text"
      i = i + 1
  Next j
  </code></pre>
  
  <p>Thanks for the help :) </p>
  
  <p><a href="https://i.stack.imgur.com/Y24wK.png" rel="nofollow noreferrer">I need the output as in this screenshot.</a></p>