I guess I got busted.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]


On Mon, 21 Dec 2009 11:44:01 -0800, Jim Thomlinson
wrote:

I notice you are using auto instancing variables??? Any reason?

Dim coll as Collection

Set Coll = New Collection

You should read this guy's web site he is a genius...
http://www.cpearson.com/excel/DeclaringVariables.aspx