Advertisement
Guest User

Untitled

a guest
Oct 20th, 2018
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. Dim counter As Long
  2. counter = 1
  3. For Each tRow In tRows
  4. If Not headerRow Then
  5. counter = counter + 1
  6. If counter > 20 Then Exit For
  7. c = 2: r = r + 1
  8. results(r, 1) = asays(asay)
  9. Set tCells = tRow.getElementsByTagName("td")
  10. For Each tCell In tCells
  11. results(r, c) = tCell.innerText
  12. c = c + 1
  13. Next
  14. End If
  15. headerRow = False
  16. Next
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement