Excel/Web bug solved!!!

P

Paul

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top