checking value in column
 

I'm currently writing a program where there are the following columns
CCL# Description Tested? Successful? Notifiied(sent email
confirmation)? Testers (First Name) Testers (Last Name) Comments


I want to check if the tested and successful column
(right now, they have a drop down list to choose between yes and no)
I only know how to do that in one cell with this:

Sub Yes()
Sheets("Sheet1").Select
If Range("C5").Value = "Yes" Then
MsgBox "Yes."
End If
End Sub


I dont' know how to choose for a range say if c5 and c6 has yes
then...

checking value in column
 

Sub Yes()
Sheets("Sheet1").Select
If lcase(Range("C5").Value) = "yes" and _
lcase(Range("C6").Value) = "yes" Then
MsgBox "Yes."
End If
End Sub

--
Regards,
Tom Ogilvy


"sals" wrote in message
om...
I'm currently writing a program where there are the following columns
CCL# Description Tested? Successful? Notifiied(sent email
confirmation)? Testers (First Name) Testers (Last Name) Comments


I want to check if the tested and successful column
(right now, they have a drop down list to choose between yes and no)
I only know how to do that in one cell with this:

Sub Yes()
Sheets("Sheet1").Select
If Range("C5").Value = "Yes" Then
MsgBox "Yes."
End If
End Sub


I dont' know how to choose for a range say if c5 and c6 has yes
then...