Nov 12 2022 08:56 AM
I've got some code to turn on iterative calculations in a Personal Macro workbook (currently on the ThisWorkbook page; I've moved it between that and Modules). The code that I'm using is below - has anyone else run into this issue and / or does anyone have feedback on where the error in the code is?
Private Sub Workbook_Open()
' Set maximum iterations to 9,999
With Application
.Iteration = True
.MaxIterations = 9999
.MaxChange = 0.001
End With
End Sub
After I updated to Windows11 I started running into broader issues with my Personal workbook and am not really sure what to do.