I'm using this code to turn the value of B17 into F7's value whenever F7 is changed. The code below is working, but when I debug it line by line, it seems like this subroutine runs 10 times or so before it exits. Why is that? Will that slow down the macro?
Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
If Range("F7").Value <> Range("B17").Value Then
Range("B17").Value = Range("F7").Value