title: How do you make a variable your active cell?
body: <p>I have used an input box to define a variant as a cell value</p>
  
  <pre><code>sub practice()
  
  Dim Value1 as Variant
  
  'Get Input Values
  Value1 = Application.InputBox(prompt:="Click Cell Value", Title:="Specify 
  Range", Type:=8)
  
  'Select Variable as the ActiveCell
  Value.Select
  
  End Sub
  </code></pre>
  
  <p>The error occurs when I try to select the variable as the activecell. Any ideas how I can do this?</p>