Thread: Case Select statements with "if" statements

Can you not use "if" statements in Case Select statements? If you can, will somebody help me figure out why I'm getting an error (Error '438') for the following code?

Code:

Select Case shift1
    Case [1]
        If (wc1 = Cells(i, 1).Value) Then
            moveData = False
        End If
    Case [2]
        If wc1 = Cells(i - 1, 1).Value Then
            moveData = False
        End If
    Case [3]
        If wc1 = Cells(i - 2, 1).Value Then
            moveData = False
        End If
    Case Else
        moveData = True
    End Select

Hi compulsiveguile,

As far as im aware you can use if in a select (not that i ever have so i could be wrong).

but, what data type is shift1? if Integer then try case 1 instead of case [1].

or if string case "1"

Originally Posted by Stuie

Hi compulsiveguile,

As far as im aware you can use if in a select (not that i ever have so i could be wrong).

but, what data type is shift1? if Integer then try case 1 instead of case [1].

or if string case "1"

It's always so simple... thanks!