title: Access Column In Array VBA
body: <p>My code begins with assigning the sheet and grabbing the row count</p>
  
  <pre><code>Set ws2 = ThisWorkbook.Worksheets("Sheet2")
  lastRow22 As Long
  lastRow22 = ws2.Cells(ws2.Rows.Count, "A").End(xlUp).Row
  </code></pre>
  
  <p>I have the following which put the entire column into an array from column 1 to 80</p>
  
  <pre><code>Dim arrEntireWs2() as Variant  
  With ws2
      arrEntireWs2 = .Range(.Cells(2,1),.Cells(lastRow22,80)).Value
  End With
  </code></pre>
  
  <p>Then I loop through it</p>
  
  <pre><code>Dim lngArrEntireWs2Index as Long
  For lngArrEntireWs2Index = LBound(arrEntireWs2,1) to Ubound(arrEntireWs2,1)
      'Things I want to do
  Next lngArrEntireWs2Index
  </code></pre>
  
  <p>My question is how do I grab the value at a certain column on the row that it is looping through? Like how would I grab what is on column 10 while going through the loop?</p>