Calculate after refreshing(VBA)

Asked Jul 29 '19 at 08:12

Active Sep 26 '19 at 13:04

Viewed 82 times

I want to calculate after refreshing, but it always refreshes after calculating. How could I modify my codes?

Sub macro()
    Workbooks(“123.xlsm”).RefreshAll
    Calculate 
End Sub

edited Jul 29 '19 at 10:05

asked Jul 29 '19 at 08:12

Lann

2

[Switch calculation off](https://learn.microsoft.com/en-us/office/vba/api/excel.application.calculation) before refreshing? – GSerg Jul 29 '19 at 08:17
Check `BackgroundQuery` parameter of objects and make sure it is `False`. – BrakNicku Jul 29 '19 at 08:19
Sorry, but both solutions failed. – Lann Jul 29 '19 at 08:40
@Lann maybe try [this](https://stackoverflow.com/a/57251527/11167163) I bet that it will help =) – TourEiffel Jul 29 '19 at 10:09

0 Answers0