AND Condition

[sevenfive85]

Hi all,

Can someone please help with this conditional statement? I need two things to be true for the word "Select" to appear, Cell D3 must be "Yes" and C8 must contain something. Code below is what I have but it is wrong, please help. Thank you.


If Target.Address = "$D$3" Then
If Target.Value = "Yes" And Range("C8").Value <> "" Then
Range("K8:K300").Value = "Select"
Else
Range("K8:K300").Value = ""
End If
End If

 

[sevenfive85]

Hi guys just one more question. I need to change the code to look for a specific character but it is giving me an error. The red highlighted is what it was and work fine but I need to change it to the yellow code to look for "#" in column C. Thank you

 

[bobsan42]

You have to replace Search with Instr.
But your comparison will never return true.
Try:

if left(inarr(i,1),1)="#" then

 

[sevenfive85]

You have to replace Search with Instr.
But your comparison will never return true.
Try:

if left(inarr(i,1),1)="#" then

@bobsan42
YES!!!! Thank you again!!!!!!!!!