Why is my SheetCalculate routine being activated so many times in Excel VBA?
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 End If Exit SubEnd Sub