Hi there, This is a weird one....
Im working on a excel system someone else created.... The first 3 columns in the sheet contains data validation dropdowns.... When you delete a row , the dropdowns appear in other columns( Ive checked the code and it doesnt seem that the validation is created in code) Ive added code to the Worksheet_SelectionChange event :
If Target.Column > 3 Then
With Selection.Validation
.Delete
.Select
End With
Exit Sub
End If
And this doesnt work .....
Any ideas?
Im working on a excel system someone else created.... The first 3 columns in the sheet contains data validation dropdowns.... When you delete a row , the dropdowns appear in other columns( Ive checked the code and it doesnt seem that the validation is created in code) Ive added code to the Worksheet_SelectionChange event :
If Target.Column > 3 Then
With Selection.Validation
.Delete
.Select
End With
Exit Sub
End If
And this doesnt work .....
Any ideas?
