Hi Guys,

Can anyone tell me why a macro should take longer everytime I run it?

I have a bit of code, nothing special, that web queries about 500 rows of
data, 4 columns wide. The macro reduces this to about 100 rows and then
copies to a new sheet.

I have set it to a test of 5 days days, so 5 web queries each run.

It seems that if I continuosly run this macro, ie over the same set of data
it takes about 7 seconds longer each time.

So first run is 12 seconds, next is 19 then 25, 31,39,46 and 53.

If I close excel completely and open it and try again it reverts to the 12
seconds first run.

Any idea why this is?


Regards,

Ron