Keeps overwriting my output

[SKPork]

I am scraping price data from websites and although I can get the exact output I am looking for in the "Immediate" window, when I try to send it to a worksheet, it overwrites the cells with earlier data output with the last output.

Please help!!

Option Explicit
Private cd As Selenium.ChromeDriver

Sub WeeklyPrices()

' Open Chrome

Dim cd As Selenium.ChromeDriver
Dim RowNum As Integer, ColNum As Integer
Set cd = New Selenium.ChromeDriver

Dim Count As Integer
For Count = 1 To 2

Dim Value As String
Dim names As Range
Set names = Range("c1:c2")
Dim cell As Range
For Each cell In names

cd.AddArgument "--headless"

cd.start
cd.get cell.Value

'Find Headers

Dim H2Headers As Selenium.WebElements
Dim H2Header As Selenium.WebElement

Set H2Headers = cd.FindElementsByCss("h2:nth-of-type(4)")

For Each H2Header In H2Headers

'Debug.Print H2Header.Text

RowNum = Count
ColNum = 1
Cells(RowNum, ColNum) = H2Header.Text

Next H2Header

' Find Prices

Dim OtdListItems As Selenium.WebElements
Dim OtdListItem As Selenium.WebElement

Set OtdListItems = cd.FindElementsByCss("ul:nth-of-type(4)")

For Each OtdListItem In OtdListItems

'Debug.Print OtdListItem.Text

RowNum = Count
ColNum = 2
Cells(RowNum, ColNum) = OtdListItem.Text

Next OtdListItem

Next cell

Next Count

cd.Quit

End Sub

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Keeps overwriting my output - OzGrid Free Excel/VBA Help Forum
and Keeps overwriting my output
and also Keeps overwriting my output

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[SKPork]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Keeps overwriting my output - OzGrid Free Excel/VBA Help Forum
and Keeps overwriting my output
and also Keeps overwriting my output

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Difficulty sourcing websites from worksheet then returning results

I am trying to write a script to scrape data from a set of websites that I have listed in a worksheet. I would like to return the scraped data to a separate worksheet. What I have not yet been abl...

stackoverflow.com