ham123
03-28-2019, 12:38 AM
Greetings Experts,
I have a code which allows me to refresh calculations for tabs, however, it is not the most versatile as it is calling tabs separately. This would not be feasible if I had 200 over tabs.
I need help editing it such that it would refresh all tabs in the workbook.
Sub Button1_Click() Application.ScreenUpdating = False
Call CopyPasteValuesInTab("Allocation")
Call CopyPasteValuesInTab("By Ctry-EIN")
Call CopyPasteValuesInTab("By Ctry-EMSB")
Call CopyPasteValuesInTab("By Ctry-ETH")
Call CopyPasteValuesInTab("By Ctry-EPC")
Call CopyPasteValuesInTab("ESD Trf Qty")
'...
ActiveSheet.Calculate
Application.ScreenUpdating = True
MsgBox "Done!"
End Sub
Any help is much appreciated! :)
I have a code which allows me to refresh calculations for tabs, however, it is not the most versatile as it is calling tabs separately. This would not be feasible if I had 200 over tabs.
I need help editing it such that it would refresh all tabs in the workbook.
Sub Button1_Click() Application.ScreenUpdating = False
Call CopyPasteValuesInTab("Allocation")
Call CopyPasteValuesInTab("By Ctry-EIN")
Call CopyPasteValuesInTab("By Ctry-EMSB")
Call CopyPasteValuesInTab("By Ctry-ETH")
Call CopyPasteValuesInTab("By Ctry-EPC")
Call CopyPasteValuesInTab("ESD Trf Qty")
'...
ActiveSheet.Calculate
Application.ScreenUpdating = True
MsgBox "Done!"
End Sub
Any help is much appreciated! :)