Often the macro stops at an undefined variable, when i "Dim" the
variable macro continues.

Variable declaration should set to 'Required' just as a *best
practice*. This can be set on the Editor tab of the VBE Options
dialog...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion