Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
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
|Excel writer in php that allows file save, NOT download||3||24|
|In Excel 2010, how do I to use countif for a number of tabs listed on the first sheet of a spreadsheet?||4||28|
|Excel -- increase row height through cell entry (via VBA)||3||26|
|update a button to have multiple words on it, and column with another background color||21||16|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!