Excel 2016 screenupdating not working

---

18-Jan-2021 19:59

It happens when there is transition among excel files.The same macro worked properly in win 7 with office 2010.

Hi Experts, I have a spreadsheet where I have created a console page to run a variety of reports from. Range("$I

Hi Experts, I have a spreadsheet where I have created a console page to run a variety of reports from.

Range("$I$1") _ , False, False, False, False, , False PVTotal = Application. Sum(Range("B2", "B" & Last Record Row)) Imp Total = Application.

Range("$C$1", "$C" & Last Record Row), False, True, , sht.

Display Alerts = False Flicker Test Helper Application.

||

Hi Experts, I have a spreadsheet where I have created a console page to run a variety of reports from. Range("$I$1") _ , False, False, False, False, , False PVTotal = Application. Sum(Range("B2", "B" & Last Record Row)) Imp Total = Application. Range("$C$1", "$C" & Last Record Row), False, True, , sht. Display Alerts = False Flicker Test Helper Application.

") _ , False, False, False, False, , False PVTotal = Application. Sum(Range("B2", "B" & Last Record Row)) Imp Total = Application. Range("$C

Hi Experts, I have a spreadsheet where I have created a console page to run a variety of reports from.

Range("$I$1") _ , False, False, False, False, , False PVTotal = Application. Sum(Range("B2", "B" & Last Record Row)) Imp Total = Application.

Range("$C$1", "$C" & Last Record Row), False, True, , sht.

Display Alerts = False Flicker Test Helper Application.

||

Hi Experts, I have a spreadsheet where I have created a console page to run a variety of reports from. Range("$I$1") _ , False, False, False, False, , False PVTotal = Application. Sum(Range("B2", "B" & Last Record Row)) Imp Total = Application. Range("$C$1", "$C" & Last Record Row), False, True, , sht. Display Alerts = False Flicker Test Helper Application.

", "$C" & Last Record Row), False, True, , sht. Display Alerts = False Flicker Test Helper Application.

Display Alerts = True End Sub Sub Flicker Test Helper() Dim current Workbook As Workbook, new Workbook As Workbook Set current Workbook = Application. Now usually it works fine but the macro im working with does calculations on 30000 ish rows (takes around 90 seconds) and causes Excel to display "Not Responding" for a short time and i see some of the calculations happening. And is there anything i can add to application.screenupdating to make sure the window doesnt change at all while the macro is running? Use the built-in Help that comes with Excel/Access 2. A lot of VBA code can be acquired by using the Macro Recorder.

---