IF, OR statement in VBA

[theta]

Hi, I have my code working well but want to expand it. Need it to therefore become an OR statement as the two conflict at present

Dim n as Name
 
For Each n In ActiveWorkbook.Names
    If n.RefersTo Like "*[[]*" Then n.Delete
    If n.RefersTo Like "*REF!*" Then n.Delete
Next n

If the first condition is met, n is deleted and so the second if statement fails as the object has gone

I need to expand it so that both IF statements can be treated as an OR.

IF x=y OR a=b THEN

Simple request I hope...

 

[theta]

A greater understanding of OR type use would help me alot.

How could I have multiple OR statements with various conditions. Would also like to use AND

 

[Andrew Poulsom]

Is it?

If n.RefersTo Like "*[[]*" Or n.RefersTo Like "*REF!*" Then n.Delete

 

[doofusboy]

Try:

If n.RefersTo Like "*[[]*" OR n.RefersTo Like "*REF!*" Then n.Delete

 

[theta]

I tried that. Gave me error. But now it works. Bizarre!

I will investigate ElseIf statements as well, they seem to be the answer for multiple IF, along with select case

Thanks guys!