If then else function

C

Coppercrutch

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.
 
J

Jim Cone

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.
 
C

Coppercrutch

Cheers Jim,

I gave that a go then worked out the problem. My "IP Corporate" was actually
"IP Corporate " !! Always the simple things, one little space after a word.

Thanks for your help.

CC
 
Top