if then and go to

[m_in_spain]

Hi,
My latest question, to me, seems much simpler that what i have previously asked, but i cannot get through it without label not defined errors, endif without this that and the other errors

I need a short piece of code that if the result of a particular cell (AA99) on Sheet33 is 1000001 then go to a particular line of code, otherwise (and the only other number it could be is 1000000) go to a line further down the code and continue from there.

I do not want to use line numbers in the code as these may change as my project grows, i tried using a label of Label1 and Label2, but this errored, i tried DIM label1 as string etc.

As i say i think this must be rather simple, but its floored me!

Help so far from here has been invaluable, please send more!

Thanks In advance

 

[mumps]

Maybe:

Sub Test()
    If Range("A9").Value = 1000001 Then
        GoTo Location1
    Else
        GoTo Location2
    End If
    
Location1:
    MsgBox ("Location1")
    Exit Sub
Location2:
    MsgBox ("Location2")
End Sub

 

[m_in_spain]

You, Sir, in my eyes, are a genius, and I thank you. Works like a dream, I'm sure it will not be too long until i am stuck again!

 

[mumps]

You are very welcome.