Ardus' question "Why do you set to Nothing local variables that will
be automatically destroyed by the End Sub ?" - I've noticed object
models which I've used have some pretty serious memory leaks when I
don't explicitly destroy objects. As Bob says, it doesn't hurt, but
it's good practice and it can be positively beneficial.
My two cents worth...
Col :)
--
colofnature
------------------------------------------------------------------------
colofnature's Profile:
http://www.excelforum.com/member.php...o&userid=34356
View this thread:
http://www.excelforum.com/showthread...hreadid=545424