excel printing

Tips for fast updates and printing in automating of Microsoft Excel

1. Use ScreenUpdating property
Application.ScreenUpdating = False
' code here
Application.ScreenUpdating = True

2. Use ADO to update xls file - is much faster than updating cell by cell

3. Use cell array - is much faster than updating cell by cell