We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
and ended with
Application.ScreenUpdating = False
I found out that this code no longer allows me to have two open workbooks where the one we open manually is visible and the other we open by VBA is not visible. This was due largely to my use of code like
Application.ScreenUpdating = True
to switch between workbooks. I've learned that using code like
resolves the flashing problem.
Workbooks(1).Sheets(intCounter).Range("C5:H5").Value = strPONumber
to let them know how the macro is progressing.
Application.StatusBar = strMsg