Hi,
I want to run a Private Sub Macro, the code is as below:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Intersect(Target, Range("V2:V664")) Is "Os" And Intersect(Target, Range("AC2:AC664")) Is "Ach" Then
Target.Value = "Movement from Os in '13 to Ach in '14"
Application.EnableEvents = True
End Sub
This is basically required to compare values in 2 columns of a sheet with rows from 2 to 664 and based on the If loop if the condition is met then populate the target column with a specific statement.
Can anyone please help me how to execute this macro
Much appreciate the helper 
Regards
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Ruel #3 requires code tags. I have added them for you because you are a new user. --6StringJazzer
Bookmarks