JohnDouglas
Board Regular
- Joined
- Jan 5, 2005
- Messages
- 239
hi guys
i've got a macro that will download every url in column 2. but now i only want it to download the url if theres a "yes" in column 9.
here's the start of my code:
any ideas how to insert a check that will see if "yes" is in column 9 of each row with a url?
thanks
john
i've got a macro that will download every url in column 2. but now i only want it to download the url if theres a "yes" in column 9.
here's the start of my code:
Code:
'----------------------------------
'Start downloads
Dim i As Long, url As String, sh As Worksheet, QName
With Sheets("Main")
For i = 7 To .Cells(65536, 1).End(xlUp).Row
strFrmFullUrl = .Cells(i, 2).Value
any ideas how to insert a check that will see if "yes" is in column 9 of each row with a url?
thanks
john