Hi again,
Thank you for responses, I appreciate you taking the time to help.
I notice from the examples posted the If, Then, Else Statement appears to draw a line under the Sub Routine and the conditions and in effect diverts to various other Sub Routines.
I have code below a simple:
If ActiveCell.Address = "$C$65536" Then Macro1
Things are not working too well .. it appears that it performs Macro1 if the condition is True and then Returns to the original code below the If statement and executes that.
I am wondering if I therefore have to do an If, Then, Else with a False condition returning to another Subroutine to finish the procedure?
I am sorry if I am making 'heavy weather' of this but it the end of a long week!
Regards
S.
Thank you for responses, I appreciate you taking the time to help.
I notice from the examples posted the If, Then, Else Statement appears to draw a line under the Sub Routine and the conditions and in effect diverts to various other Sub Routines.
I have code below a simple:
If ActiveCell.Address = "$C$65536" Then Macro1
Things are not working too well .. it appears that it performs Macro1 if the condition is True and then Returns to the original code below the If statement and executes that.
I am wondering if I therefore have to do an If, Then, Else with a False condition returning to another Subroutine to finish the procedure?
I am sorry if I am making 'heavy weather' of this but it the end of a long week!
Regards
S.