Hi,

Plzzz help...I have the following code in worksheet_selectionchange.
I believe the code-If ActiveCell.Address = "H"&i- does not work.
In column F, I have drop down list with 'Yes' or 'No' as options.
If the user chooses 'Yes' in column F, check if user has skipped column G and moved to column H in which case the mesg pops up saying column G cant be blank. If it is not blank, then do a few vlookups on the next few cells.
What part of my code is faulty?


For i=2 to 10
If Range("K" & i) = "" Or Range("L" & i) = "" Then
If Target.Row = i And Target.Column = 6 Then

If Range("F" & i).Value = "Yes" Then
If ActiveCell.Address = "H" & i
         If Range("G" & i) = "" Then
            MsgBox ("Column G cannot be blank if you choose 'yes'.")
            Range("F" & i).Select
            else
           blah blah
           end if
else If Range("F" & i).Value = "No" Then
         blah blah
        end if
end if
else
end if
else 
end if


next i