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