Compare strings

[dempa79]

This i the code that i have written to compare strings..

If Cells("F" & x).Value = "RedemtionFunds" Or "Sell" Then

x3 = Range("f" & x).Offset(0, -1).Value * x2

else

Msgbox()

End if

But when i try it i get an error message about datatypes...

The thing i that i would like to compare if the text in my cells is equal to "RedemtionFunds" or "Sell".

 

[Andrew Poulsom]

You have to repeat the test:

If Cells("F" & x).Value = "RedemtionFunds" Or Cells("F" & x).Value = "Sell" Then

 

[jindon]

shoud be

Cells( x,"f").value = "RedemtionFunds" Or Cells(x,"f").value = "Sell" Then