If you're code deletes/inserts rows or columns, maybe adding something like this
to the top will speed it up.

ActiveWindow.DisplayGridlines = False

If you leave those little dashed lines in the display, then excel figures it has
to determine where they go each time you insert/delete rows. And if you're
doing a lot of that kind of stuff, it can slow things down a lot.



tang lk wrote:

I write a simple VBA program to extract certain info from different files
(same format).

After running for few times, the program become very slow and need to close
and reopen the excel file again in order to make the VBA program faster.

Any idea why it happen ?

regards

--

Dave Peterson