title: Type Mismatch with Column number
body: <p>I am not able to understand why excel says that my code returns a type mismatch error number 13 in the following lines of code:</p>
  <pre><code>Sub MySub()
  Dim destinationWs As Worksheet
  Dim DataColumn As Long, ShareColumn As Long, Number As Long
  Set destinationWs = ThisWorkbook.Worksheets(&quot;Sheet1&quot;)
  
  DataColumn = destinationWs.Columns(6)
  ShareColumn = destinationWs.Columns(7)
  Number = destinationWs.Columns(3)
  
  (.....)
  End Sub
  </code></pre>
  <p>Thank you in advance</p>