| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scripting.Dictionary question
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SCRIPTING | Excel Programming | |||
| Scripting Question | Setting up and Configuration of Excel | |||
| Newbie VBE scripting question | Excel Programming | |||
| VBA - running scripting dictionary (error!) | Excel Programming | |||
| VBA question - Set reference to run Scripting.Dictionary | Excel Programming | |||
Hybrid Mode
