Select Case using AND

[christian2016]

Hi Guys,

Not sure why I can't use the and in my Case. I get a run-time error 13.

Any help is greatly appreciated.

Thanks

ConfigType = LCase(Config_Cells.Offset(0, Partner - 5))
            ConfigValues = Config_Cells.Offset(0, Partner - 4)
            
  
            Select Case ConfigType
            Case "formula" And ConfigHeading = "test"

             End Select

 

[Joe4]

If you want to use Select Case, I believe you will need to nest them, as I believe each Select Case statement can only refer to one variable, i.e.

            Select Case ConfigType
                Case "formula" 
                     Select Case ConfigHeading 
                          Case "test"
                           ...
                     End Select
                     .... 
             End Select

If you used an IF...THEN, then you can do it in one, i.e.

If (ConFigType = "formula") And (ConfigHeading = "test") Then
    ...
End If

 

[Peter_SSs]

If you really want to use Select Case, you can do it like this

Select Case True
  Case ConfigType = "formula" And ConfigHeading = "test"
    

End Select