If ... Then statement Compile Error

[Twisted_Squeegie]

Im getting a "Compile error: Expected: Then or GoTo" in an If ... Then statement.
My worksheet comes from a data logger that can record 20+ channels of data. The number of channels and channel numbers can change depending on the setup. If the channel is not being recorded the column header is labeled as "OFF" (with the quotes). Im trying to write a little snippet that will delete any columns that are not used.

col = 22
Do Until col = 2
if Cells(5, col).Value = " "OFF"" Then ' The value of the cell has a space then "OFF"
Columns(col).Delete
'do some stuff
Else
'do some other stuff
End If
col = col - 1
Loop

 

[mumps]

Try:

if Cells(5, col).Value = " OFF"

 

[Fluff]

How about

If Cells(5, Col).Value = Chr(34) & " OFF" & Chr(34) Then

 

[Norie]

Try this.

col = 22
Do Until col = 2
    If Cells(5, col).Value Like "*OFF*" Then ' The value of the cell has a space then "OFF"
        Columns(col).Delete
        'do some stuff
    Else
        'do some other stuff
    End If

    col = col - 1

Loop

 

[Twisted_Squeegie]

Bingo! Third times a charm.
The first two didnt give me errors but just skipped to Else.
Thanks!