Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Egidius Bakker   on Nov 12 In MS Office Category.

  
Question Answered By: Bobbie Gonzalez   on Nov 12

Try

Application.ScreenUpdating = False

It might speed it up.

It might also be that you can get away without using the select statements and
that this might speed it up:


ActiveDocument.Tables(TableCount).Copy
ExcelSheet.Application.Cells(RowNumber,ColumnNumber).Paste

If you're not doing the selects, the screens might not be redrawn.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 


Tagged: