Hi All
I was wondering if this is the best way to calculate sheets using VBA.
I've read that ActiveSheet.Calculate is not recommended.
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Calculate
ThisWorkbook.Sheets("Multi Build").Calculate
ThisWorkbook.Sheets("Patch By Universe").Calculate
ThisWorkbook.Sheets("Power Map").Calculate
ThisWorkbook.Sheets("Distro BO's").Calculate
End Sub
Thanks!
Russ
I was wondering if this is the best way to calculate sheets using VBA.
I've read that ActiveSheet.Calculate is not recommended.
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Calculate
ThisWorkbook.Sheets("Multi Build").Calculate
ThisWorkbook.Sheets("Patch By Universe").Calculate
ThisWorkbook.Sheets("Power Map").Calculate
ThisWorkbook.Sheets("Distro BO's").Calculate
End Sub
Thanks!
Russ