Check out Mark Johnson's blog post to help Microsoft customers speed up their VBA, with 9 quick tips to improve VBA macro performance. The tips have been collected from Blog posts from Microsoft field engineers and Microsoft MVPs like Charles Williams and Jan Karel Pieterse.
Do yourself a favor and take a look 