Try it this way to see what is happening...
'--
Sub Mystery()
On Error GoTo Huh
If ActiveCell.Value = "IP Corporate" Then
GoTo Corporate1
Else
GoTo Group1
End If

Corporate1:
MsgBox "Yes"
Exit Sub
Group1:
MsgBox "No"
Exit Sub

Huh:
Beep
MsgBox Err.Number & vbCr & Err.Description
End Sub
'--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Coppercrutch"
wrote in message
I have the following code:
If ActiveCell = "IP Corporate" Then
GoTo Corporate1
Else
GoTo Group1
End If
When I hover over the 'activecell' when running the code is states "IP
Corporate" as I expect it to because the activecell is "IP corporate" - (In
exactly the same format). But instead of going to Corporate1 it ignores this
and goes straight to 'Else' ? I can't understand why this simple if function
is not working. It doesn't seem to acknowledge the activecell ?
Any help much appreciated.