I am new to macros and I need to create a macro with an if statement. What
is the correct format, including spacing to make this work? I know the
wordin is If and else, but I can't seem to get the right format. Lets say if
A1=1 I want the first macro to work, if A1=2 I want the 2nd macro to work,
and if A1=3 the third.

Sub

Macro

End Sub

Sub

Macro

End Sub

Sub

Macro

End Sub

Any help would be appreciated, like I said I just can't quite make it work.

Thank you,

Lisa12