title: excel vba fill column from 1 to N
body: <p>I am trying to write a VBA code to autofill range A1:A10000 with numbers 1 to 10000 but without entering 1 in A1 and 2 in A2 to create a range.</p>
  
  <p>Basically, I need a code that looks like this:</p>
  
  <pre><code>Set fillRange = Worksheets("Sheet1").Range("A1:A10000")
  (1,2).AutoFill Destination:=fillRange
  </code></pre>
  
  <p>Of course this does not work, but you get what it.</p>