Need to start code from a certain point

[Sharid]

Hi

In my workbook I have two sheets

Sheet1 = "Scraper"
Sheet2 = "Url List"

In Sheet 2 Column "A" Row 2 I have a list of URLs, every time one has been processed my code place a NUMBER "1" in column B next blank row.

The number "1" have two purposes, one as a counter and two to indicate that the this cell has been processed. What I need is for my code to ONLY run on urls that do not have the number 1 in column B sheet2

Sheet2

URLS	3
https://www.mysite.com	1
https://www.thissite.co.uk	1
https://www.yoursite.com	1
https://www.supersite.co.uk
https://www.funsite.com
https://www.bestsite.com
https://www.helpfulsite.com

<tbody>
</tbody>

In the above example the first 3 urls have been processed, therefore when the code is run again it will start from the 4th url https://www.supersite.co.uk

Something like an IF Statement e.g.

IF Sheet2. "Url List" column "B" = "" then

MY CODE HERE

Else

IF Sheet2. "Url List" column "B" = 1 then

Start my code from here

If There are NO urls left to process then message box "Process completed, there is nothing to process"

Thanks

 

[DanteAmor]

Try this

Sub test5()
    Dim sh2 As Worksheet
    Set sh2 = Sheets("Url List")
    For i = 2 To sh2.Range("A" & Rows.Count).End(xlUp).Row
        If sh2.Cells(i, "B").Value = "" Then
            'MY CODE HERE
        
        ElseIf sh2.Cells(i, "B").Value = 1 Then
            'Start my code from here
            
        End If
    Next
    MsgBox "Process completed, there is nothing to process"
End Sub

 

[Snakehips]

Sharid,
You appear to be suggesting that the URLs will be processed sequentially?
Your code must currently be starting the process with reference to say Cell A2 or Row 2 ?
You can maybe alter that to be A2 or Row2 , OFFSET by the total you have in B1 ?

Hope that helps.