View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Coppercrutch Coppercrutch is offline
external usenet poster
 
Posts: 5
Default If then else function

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.