if or statement

[Guest]

how would i go about doing:
if range("nightly!cu9").value = "AT&T" or "Verizon" then
application.run "addfeatures"
end if

i dont know how to do the OR part
thanks in advance

 

[daverico]

One way is to write:
if range("nightly!cu9").value = "AT&T" then
application.run "addfeatures"
elseif range("nightly!cu9").value = "Verizon" then
application.run "addfeatures"
end i

 

[JulieD]

Hi
one way

if range("nightly!cu9").value = "AT&T" OR range("nightly!cu9").value
="Verizon" then
application.run "addfeatures"
end if

Cheers
JulieD

 

[Bob Phillips]

Bit neater <g>

With range("nightly!cu9")
If .value = "AT&T" OR .value ="Verizon" then
application.run "addfeatures"
end if
End With

 

[Dave Peterson]

One more:

select case lcase(worksheets("nightly").range("cu9").value)
case is "at&t","verizon": call addfeatures
end select

I like that format for the range.
I checked for Verizon in any case (VeRiZoN, VERIZON, verizon will all be ok)

And if addfeatures is in the same workbook (and it looks like it to me), you can
just call it--you don't need application.run.