Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro speed decreesing after each run
I have a macro that refreshes a query to a database on the network,
returns the data and then the macro goes thru the data and creates a formated output of just the data from the query that is needed. It deletes most of the lines of data from the query and only keeps the few that it needs. My problem is that every time I run the macro it takes 4-5 seconds longer each time. Here are my timings, 8,12,17,21,25,30,34,38,42,47 I have searched on clearing memory and have not found anything helpfull. I have turned off autocaclulate and other correction options in Excel but see the same increase in run time. If I close the spreadsheet and open it again it start over at about 8 seconds and each sucsesive run takes 4-5 seconds longer again. I do have a user form that pops up but it gets unloaded. Anythought sour suggestions as to where to start looking? Thanks Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Speed of Macro on 2 PC | Excel Programming | |||
Speed up macro | Excel Programming | |||
Need to Speed Up A Macro | Excel Programming | |||
Speed Up this macro? | Excel Programming | |||
Speed-up a macro! | Excel Programming |