title: How to Fill Column Loop? VBA Excel
body: <p>So i would like to make a loop that autofills the same column throughout all worksheets. I recorded the macro but obviously that is a lot of code. I tried to use a loop, but some of the variables i want to autofill with have numbers at the end (e.g. "ULA2"), And so with auto fill it would make the entire column ULA2, ULA3, ULA4,... How can I correct this? Here is my code:</p>
  
  <pre><code>Sheets("ULA2").Select
      Range("F2").Select
      ActiveCell.FormulaR1C1 = "ULA2"
      Range("F4").Select
      ActiveCell.FormulaR1C1 = "ULA2"
      Range("F5").Select
      ActiveCell.FormulaR1C1 = "ULA2"
      Range("F6").Select
      ActiveCell.FormulaR1C1 = "ULA2"
      Range("F7").Select
      ActiveCell.FormulaR1C1 = "ULA2"
      Range("F8").Select
      ActiveCell.FormulaR1C1 = "ULA2"
      Range("F9").Select
      ActiveCell.FormulaR1C1 = "ULA2"
      Range("F10").Select
      ActiveCell.FormulaR1C1 = "ULA2"
      Range("F11").Select
  
  LastRow = Cells(Rows.Count, "F").End(xlUp).Row
  Range("F2").AutoFill Destination:=Range("F2:F" &amp; LastRow), Type:=xlFillDefault
  
  Sheets("BO").Select
      Range("F2").Select
      ActiveCell.FormulaR1C1 = "BO"
      Range("F2").Select
      Selection.AutoFill Destination:=Range("F2:F"), Type:=xlFillDefault
      Range("F2:F").Select
  </code></pre>