Vb net screenupdating

I tried this code and while it did run, it didn't "quite" work.Side note - We cannot simply upgrade to a higher version of Office or Windows without spending ,000 for the vendor to supply the proper software for these heavy machines.

vb net screenupdating-76vb net screenupdating-10

I am pooling (with a While loop) the entire worksheet to process each cell …

The Table references the Species column in a Table named Table3.

To learn more about efficient selection methods when using VBA, read Excel tips: How to select cells and ranges efficiently using VBA.

Other than that you can play with core console (not highly recommended).

I'd avoid the VBA approach as (personal preference) any speed you gain from working silently in the background you lose to interop.

Leave a Reply