Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,064
- Office Version
- 2016
- Platform
- Windows
Could someone please help.
I have two sheet on a workbook
Sheet1 = "Data"
Sheet2 = "URL LIST"
My code process a large amount of urls, this bit works fine. The data is input into sheet1.
Everytime it has proccesed a URL from sheet2 it places a number 1 in Column F on every row of processed url.
If i had 5000 url and i only processed 3596 and then I stopped the code. When I restart it I need it to start from 3595 and not from the begining.
i.e. It will check column F Sheet2 and if there is a Number 1 in it the code will ignore that URL
Problem I have is that it starts from the begining again.
Thanks for haveing a look
I have two sheet on a workbook
Sheet1 = "Data"
Sheet2 = "URL LIST"
My code process a large amount of urls, this bit works fine. The data is input into sheet1.
Everytime it has proccesed a URL from sheet2 it places a number 1 in Column F on every row of processed url.
If i had 5000 url and i only processed 3596 and then I stopped the code. When I restart it I need it to start from 3595 and not from the begining.
i.e. It will check column F Sheet2 and if there is a Number 1 in it the code will ignore that URL
Problem I have is that it starts from the begining again.
Thanks for haveing a look