title: Create a table that is sized based on user input in Excel?
body: <p>For the record, I'm using Excel 2010.</p>
  
  <p>I'm trying to teach myself VBA for a job at work (they give the interns the VBA stuff...), and I'm getting stuck on the simplest of things.</p>
  
  <p>I am trying to make a bordered table that is three columns wide. The amount of rows in the table has to be based on the amount of inputs the user has. In my code, that is the value given for <code>Count</code> by the user.</p>
  
  <p>My issue is that I have no idea how to select the range I need. The only way I know how to select a range is using:</p>
  
  <pre><code>ActiveCell.Range("Top left cell:Bottom right cell").Select
  </code></pre>
  
  <p>If it were from <code>A1</code> to <code>C8</code>, how do I make that work? I wish it would just work like:</p>
  
  <pre><code>ActiveCell.Range("A1:C(count)").Select
  </code></pre>
  
  <p>This is what I have so far:</p>
  
  <pre><code>Option Explicit
  Dim Count As Long
  Dim CFLArray() As Variant
  Sub TableCreation1()
      Range("A1").Select
      ActiveCell.FormulaR1C1 = "Time (days)"
      ActiveCell.Offset(0, 1).Range("A1").Select
      ActiveCell.FormulaR1C1 = "CFL (measured)"
      ActiveCell.Offset(0, 1).Range("A1").Select
      ActiveCell.FormulaR1C1 = "De (estimated)"
      ActiveCell.Offset(0, -2).Range("A1:C1").Select
      Selection.Font.Bold = True
      ActiveCell.Columns("A:A").EntireColumn.EntireColumn.AutoFit
      ActiveCell.Offset(0,1).Columns("A:A").EntireColumn.EntireColumn.AutoFit
      ActiveCell.Offset(0,2).Columns("A:A").EntireColumn.EntireColumn.AutoFit
      ActiveCell.Select
  End Sub
  
  Sub FindRange()
      Range("A2").Select
      Count = InputBox("How many pairs of data do you have? ")
  End Sub
  </code></pre>
  
  <p>I taught myself VBA a day or so ago using a book my work had, but I couldn't find anything along these lines in there. My internet searches failed as well. The worst part is I know it's going to be incredibly simple.</p>