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