title: Unable to get a specific Cell value from a Table
body: <p>I need to port some <code>VBA</code> code to a <code>VB.Net</code> addon, but I can't get a particular cell value from my Table.<br></p>
  
  <p>I am able to change <code>Range(2,2)</code> to <code>"Test"</code> but <code>table.Range(2, 2).ToString</code> gives <code>System.__ComObject</code> as Value.<br></p>
  
  <p><a href="https://i.stack.imgur.com/CxWcx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CxWcx.png" alt="This is Image of my table"></a></p>
  
  <pre><code>Private Sub Button1_Click(sender As Object, e As RibbonControlEventArgs) _
  Handles Button1.Click
  
      Dim table As Excel.ListObject
      table = Globals.wsTables.ListObjects("vehicleDefinations")
      table.Range(2, 2) = "Test"
  
      Dim file As New System.IO.StreamWriter _
      ("C:\Users\Ryzen2600x\Downloads\Debug.txt", False)
      file.WriteLine(table.Range(2, 2).ToString)
      file.Close()
  
  End Sub
  </code></pre>