Macro Run to Slow..How to improve?

  • Thread starter Thread starter geniusideas
  • Start date Start date
That kind of depends on what the macro is doing as to how to speed it
up. A couple of general tips would be to git rid of any .Select
statements that aren`t absolutely essential and include
"Application.ScreenUpdating = False" at the start of your macro and
"Application.ScreenUpdating = True" at the end.
 
Try turning calculation off at the start and back on at the end.

Application.calculation = xlmanual or xlautomatic

and to force a calc during your macro:

Application.calculate

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to run macro immediately after refres button? 1
Immediately run macro when import text data. 3
How to display create date for the workbook in a cell. 1
Columns to Rows to if more than 254. 2
How arrange from one cell to column. 4
Run Macro If Cell have "x" value 0
SNR improved after VDSL modem change 13
A solution to Excel2007 slowness when running Excel 2003 macros 1

Back
Top