<p>I have a vba macro which runs a loop for about 200 iterations, using up the ram page file as it runs.</p>

<p>I need some kind of quick fix to clear the page file after every iteration. I know the best fix would be to clean up the code, but time is a constraint here.</p>

At the end of each loop iteration set any objects that will be re-created to
```
Nothing
```
.
This
article
explains it in detail.