ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel/Web bug solved!!! (https://www.excelbanter.com/excel-programming/275568-excel-web-bug-solved.html)

Paul

Excel/Web bug solved!!!
 
A few days ago I reported that when Excel was put on an
Intranet, some cells did not change properly as the VB
script was running.

I found the solution. The cells are updating properly.
What is <not updating is the Internet Explorer screen
refresh. To get around this, I have each script end by
jumping to a blank worksheet, then back to the sheet with
the problem. This jumping results in the proper screen
refresh of the last sheet.

Do I become a VIP as a result of this astounding
discovery?

Paul



All times are GMT +1. The time now is 08:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com