Excel 2016 screenupdating not working

I am using and need to use sheetname.activate within each of the report subroutines.

The same macro worked properly in win 7 with office 2010.

Calculation = xl Calculation Manual Dim s Conn Params, s SQL As String Dim db File, db Path, db Name As String This Workbook. Select db File = "Counsellor Data.mdb" db Name = "Counsellor Data" db Path = Sheet3.

Right(db Path, 1) "\" Then ' if last char in db Path has no slash Range("databaselocation"). Value & "\" db Path = db Path & "\" End If does Folder Exist (db Path) 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.


Leave a Reply