Hi,
I would like to run a macro which consists of two macros which run in a sequence.
So say the first macro is Macro1 and the second is Macro2. Here's what I have
Private Sub Worksheet_Change (ByVal Target As Range)
Select Case Target.Column
Case is=4,5,6,7
Application.EnableEvents =False
Call Macro1
Application.EnableEvents =True
End Select
Call Macro2
End Sub
I tried the above command but it is not working. Infact, the part till 'End Select' is not working correctly when I add 'Macro2' after that. However, if I exclude 'Call Macro2' from this command, then it runs properly without any problems or errors.
Can someone please let me know the error in the above code? So basically till 'End Select' I want the command to run first, and then after that I would like Macro2 to run automatically.
Any help would be greatly appreciated!
I would like to run a macro which consists of two macros which run in a sequence.
So say the first macro is Macro1 and the second is Macro2. Here's what I have
Private Sub Worksheet_Change (ByVal Target As Range)
Select Case Target.Column
Case is=4,5,6,7
Application.EnableEvents =False
Call Macro1
Application.EnableEvents =True
End Select
Call Macro2
End Sub
I tried the above command but it is not working. Infact, the part till 'End Select' is not working correctly when I add 'Macro2' after that. However, if I exclude 'Call Macro2' from this command, then it runs properly without any problems or errors.
Can someone please let me know the error in the above code? So basically till 'End Select' I want the command to run first, and then after that I would like Macro2 to run automatically.
Any help would be greatly appreciated!