Hi All,
Having trouble with below code which activates when Cell D6 in a drop down box is selected to "Yes".
Code executes as i would like but it crashed my excel pretty much instantly once executed. Is this due to the code continuously running because D6 is "Yes"?
Private Sub Worksheet_Change(ByVal Target As Range) If Range("D6").Value = "Yes" Then Range("F36:G36").Copy Range("F6:G6") End If End Sub
Bookmarks