Hi - I'm wondering if I can define a letter, "X", to represent multiple values in an If/Then statement. The code is not complete and just an example of what i would like to do:
Code:
x="Apples", "Oranges", "Pears", "Grapes", "Banana", "Strawberry", "Blueberry"
If Sheet1.Range("A1") = x Then
Rest of Code
End If