Select Case Issue

[KerryFSA]

In general, is/are there condition(s) in which Excel VBA will not recognize a "Select Case" statement? My current project is failing to compile (Error: Case without Select Case)) even though "Select Case" is obviously in the code just above the first case. (It is not within another Select Case block.)
Thanks.

 

[njimack]

If it's a compile error then either the syntax or structure of your code is wrong. I've often code fail to compile because of a simple typo.

If you post your code there's a good chance we can fix it.

 

[shg]

This code will generate that error:

Sub KFSA()
  Select Case Range("A1").Value
    Case "Bob"
    If Range("B1") = "Joe" Then
      Case "Jim"
      ' ...
    End If
  End Select
End Sub

See the problem?

 

[Fluff]

Along with the If statement shown by shg

Loops & with statements can cause the same problem

 

[KerryFSA]

The first thing that occurred to me was a looping error as per shg.
I've since transferred the project back to my iMac from my PC and the Case problem has disappeared, only to be replaced by the Sort problem described in another thread. Go figure.

Thanks for your replies. njimack - if problem recurs, I will post code.