Thanks guys!

Leo


"Dave Peterson" skrev i en meddelelse
...
Chip Pearson has some notes, too:
http://www.cpearson.com/excel/variables.htm
Look for: Don't Use The New Keyword In A Dim Statement


Leo Heuser wrote:

"Bob Phillips" skrev i en meddelelse
...
Also it is bad practice to declare an object as New, it may get created
when
you least expect it, far better to us

Dim mares As Scripting.Dictionary

Set mares = New Scripting.Dictionary


--
HTH

Bob Phillips


Hi Bob

I don't understand your comment. If declared as New,
the object is *always* created the first time the
variable is used (as expected!?).
When is this bad?

Leo

--

Dave Peterson