Since their values never change, they are evaluated only once when your code is compiled, rather than each time they are used at run time.
This is closely tied with Specific Object Type Declaration.
I'm not sure why Screen Updating should affect the issue I am having.
Quit Set xl WB = Nothing Set xl App = Nothing Ace Man -- I gave this a try and it had no effect.
Hi all, I have a macro that executes ~200 queries which modify the data, create some tables etc.
The macro runs when the user clicks a button on a form.
Is there a way to automatically minimize/hide query windows or disable screen update?
You can use Excel's standard worksheet functions in your VBA code, rather than writing the functions in VBA.
Since these are fully executable instructions in native code, rather than interpreted VBA code, they run much faster.
A form's Resize event as well as firing when a user resizes a form, also fires when a form is loaded.
For example, this code will resize a sub-form within a resized form: [font=Verdana][size=2]You should not have to do all that.