title: Excel VBA Inputbox - Select range (Type 8) but not as a fixed range i.e. A1 not $A$1
body: <p>I currently have the following line in my <code>VBA</code> code for an <code>Inputbox</code>:</p>
  
  <p><code>Set myValues = Application.InputBox("Please select on the spreadsheet the first cell in the column with the values that you are looking for:", Type:=8)</code></p>
  
  <p>However when I select the cell it automatically inputs e.g. <code>$A$1</code>. Can this be changed, without the user having to manually delete the $, so that the <code>Inputbox</code> would automatically pick up the cell reference as <code>A1</code>?</p>
  
  <p>It is part of an automated <code>VLookup</code> macro which works perfectly aside from the <code>VLookup</code> value being fixed in the whole column.</p>
  
  <p>Thanks in advance.  </p>
  
  <p><strong>Update - Here is the full code:</strong></p>
  
  <pre><code>Dim FirstRow As Long
  Dim FinalRow As Long
  Dim myValues As Range
  Dim myResults As Range
  Dim myCount As Integer
  
  Sub VlookupMacroNew()  
  
  Set myValues = Application.InputBox("Please select on the spreadsheet the first cell in the column with the values that you are looking for:", Default:=Range("A1").Address(0, 0), Type:=8)
  
  Set myResults = Application.InputBox("Please select on the spreadsheet the first cell where you want your lookup results to start:", Type:=8)
  
  myCount = Application.InputBox("Please enter the column number of the destination range:", Type:=1)
  
  On Error Resume Next
  myResults.EntireColumn.Insert Shift:=xlToRight
  Set myResults = myResults.Offset(, -1)
  FirstRow = myValues.Row
  FinalRow = Cells(65536, myValues.Column).End(xlUp).Row
  
  Range(myResults, myResults.Offset(FinalRow - FirstRow)).Formula = _
  "=VLOOKUP(" &amp; Cells(FirstRow, myValues.Column).Address &amp; ", " &amp; _
  "'S:\Payroll\CONTROL SECTION\[Latest Data.xls]Sheet1'!$A$1:$B$100" &amp; ", " &amp; myCount &amp; ", False)"
  </code></pre>
  
  <p>myValues would begin in e.g. Cell A2 however as we are working with dynamic lists I would need the lookup value to change to A3, A4, A5 etc as the formula is copied down the list. By the inputbox using $A$2 the lookup formula only looks at that cell reference.</p>