View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
palo palo is offline
external usenet poster
 
Posts: 13
Default Does VBA support multi-thread?

Thank you very much. I want to get the information of multithread in VBA. Can
I do this with VB6?

"Joel" wrote:

There are ways of speeding up the code. Post code if possible

Some tricks are to turn off screen up[dating and turn off events

Application.ScreenUpdating = False
Application.EnableEvents = False

If yu are deleting rows delete all the rows in one instruction rather than
one line at a time. I usually mark the rows I want to delete and then use
the mark to sort the rows I want to delete so the are all adjacent. There
are other tricks but without seeing the code I can't determine what is
slowing down your code.