Hello everybody
I am newbie at vba
Can someone help me please?
I,ve got the bellow code and working indepedent at each row 4,5 with target column B
What i want is to make it work until row 50,without to repeat the code 50 times
Note i want to work the rows indepedent and NOT let say if clear contents C4:G4 to clear
as well C5:G5 etc
If Not Intersect(Target, Range("B4")) Is Nothing Then
If UCase(Range("B4")) = "" Then
Application.EnableEvents = False
Range("C4:G4").ClearContents
Application.EnableEvents = True
End If
End If
If Not Intersect(Target, Range("B5")) Is Nothing Then
If UCase(Range("B5")) = "" Then
Application.EnableEvents = False
Range("C5:G5").ClearContents
Application.EnableEvents = True
End If
End If
Thanks
Bookmarks