Hi all,

I have a file which loops through a number of files and performs an action on them.

The shortened vba is as follows:


For each cl in rng

workbooks.open (cl.value)
Application.StatusBar = "Updating " & cl.value

For each clUpdate in rngUpdate

wbMaster.Worksheets(ws.Name).Range(clSt.Address, clEnd.Address).Formula = ws.Range(clSt, clEnd).Formula

next cl

next cl


This issue i have is that application.status bar line works in excel 2016 but does not work in excel 2016.

In addition the green title bar at the top of the screen flickers.

Note that at the start of the code I have the following

Application.ScreenUpdating = False
Application.EnableEvents = False
Application.Calculation = xlCalculationManual


Any tips on how to deal with these issues would be very much appreciated.

Thanks in advance