Hi i have an excel workbook with many sheets some of which have table formulas. Pressing F9 takes a long time to calculate. I think VBA can help but i am not sure why the following code would not work (doesnt loop through the next sheets after the first).
Sub Calculate()
Dim MySheet As Worksheet
Dim Counter As Integer
For Each MySheet In ActiveWorkbook.Sheets
ActiveSheet.Calculate
Next MySheet
End Sub
Appreciate any help