VBA download url in column 2 if "yes" in column 9

[JohnDouglas]

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:

'----------------------------------

'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

 

[JohnDouglas]

ah yes, <hangs head in shame> that was left over from me previously trying to sort out problems with incrementing - or with what i thought was incrementing problems.

 

[Norie]

John

It's pretty hard to follow the flow/logic of your code because of the lack of indentation and your nested Withs.

Where should the code go if there isn't a yes in column I?

 

[JohnDouglas]

i think it should go to after the sheet is named.

i did try, but couldn't if statement to work. but like you say the codes a mess. maybe i should work on the structure a bit and trim it a little. then post back?

'-------------------------------------------------------------
            
'************ code should go to here i think

'intCnt = intCnt + 1
        Next
    End With

 

[Norie]

John

That would help I think.

I gave it a try myself but soon got lost.