title: Get Cell at Row n and Column (by name)
body: <p><strong>System Description:</strong> I have a spreadsheet with a table called <em>RentLogs</em> in a spreadsheet (Sheet2, <em>Renting Logs</em>). When you click a button, a userform appears and the user selects the date the item was returned and hits "OK". The form then searches the table for the item's ID and logs the check in date in the <em>Check In Date</em> column.</p>
  
  <p><img src="https://i.stack.imgur.com/9RtOq.png" alt="enter image description here"></p>
  
  <p><strong>Problem:</strong></p>
  
  <p>1) My VBA code (below) can only find the item ID on the whole sheet, how do I find it's location in the table so the table can be moved without worrying about static column values? <br>
  2) How do I get the VBA to drop it in the (item id's row, <em>Check In Date</em> column)?</p>
  
  <pre><code>Private Sub checkout_cmdbutton_Click()
      Dim ws As Worksheet
      Set ws = Worksheets("Renting Logs")
  
      Const WHAT_TO_FIND As Integer = 200
  
      Set FoundCell = ws.Range("RentLog").Find(What:=WHAT_TO_FIND, SearchOrder:=xlRows, SearchDirection:=xlNext, LookIn:=xlValues)
      If Not FoundCell Is Nothing Then
          MsgBox (WHAT_TO_FIND &amp; " found in (" &amp; FoundCell.Row &amp; "," &amp; FoundCell.Column &amp; ")")
      Else
          MsgBox (WHAT_TO_FIND &amp; " not found in RentLog")
          Exit Sub
      End If
  
  'copy the check in date to the table
      ws.Cells(FoundCell.Row, ws.Range("RentLog").Column).Value = Me.checkin_datepicker.Value
  
  'clear userform
      Me.checkin_datepicker.Value = Date
  
  'close userform
  Unload Me End Sub 
  </code></pre>
  
  <p><strong>My Attempt:</strong> I know the problem lies in my searching algorithm but I'm not familiar with VBA and don't know all the properties of objects. The userform works perfectly so no problem there.</p>