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
Bookmarks