Well, of course. The Change Event Sub only runs after you change G3.The original code you sent to me (below) will work if I toggle between YES and NO after doing the CLEAR
Add this line as the first line in the subThen Clear the cellsPrivate Sub Worksheet_Change(ByVal Target As Range) MsgBox"Running the Change sub." 'etc '