Hi all
I have a drop down list and wish so that everytime i change the first list, it clears the dependant list to the right of it. I want it to loop to infinity, but I just cant figure it out.I found the folllowing code which clears the cell, but is set only to clear a specific cell.
I hope someone can help me!![]()
If Not Intersect(Target, Range("A2")) Is Nothing Then Range("B2").ClearContents End If
![]()
Bookmarks