Reports

I followed vba code that made a change in an excel worksheet that I wanted displayed with:

Application.ScreenUpdating = True
Application.Wait Now + TimeValue("0:00:01") ' wait 1 second
Application.ScreenUpdating = False

If the vba code starts from a routine executed from a button on a worksheet different from the one I wanted displayed, I got to the worksheet ws to be displayed with

Dim sh1 As Worksheet: Set sh1 = Sheets("ws") 

sh1.Visible = True
sh1.Select

79401139