Can someone tell me the difference in these two subs, if any difference at
all?

Sub BuildCollections()

Dim colAssignedDepts As Collection

Set colAssignedDepts = New Collection
With colAssignedDepts
.Add chkEngineering
.Add chkGraphProd
' add other checkboxes
End With
End Sub

Sub BuildCollections()

Dim colAssignedDepts As New Collection

With colAssignedDepts
.Add chkEngineering
.Add chkGraphProd
' add other checkboxes
End With
End Sub
--
Cheers,
Ryan

Ryan,

If you google things like ' "as new collection" "as collection" including:

http://discuss.fogcreek.com/joelonso...w&ixPost=24747

http://groups.google.com/groups?q=%2...L_enUS250US250

http://www.dailydoseofexcel.com/arch...ult-instances/

hth,

Doug

"RyanH" <(E-Mail Removed)> wrote in message
news:B76F1E22-740B-4ABF-B8A1-(E-Mail Removed)...
> Can someone tell me the difference in these two subs, if any difference at
> all?
>
> Sub BuildCollections()
>
> Dim colAssignedDepts As Collection
>
> Set colAssignedDepts = New Collection
> With colAssignedDepts
> .Add chkEngineering
> .Add chkGraphProd
> ' add other checkboxes
> End With
> End Sub
>
> Sub BuildCollections()
>
> Dim colAssignedDepts As New Collection
>
> With colAssignedDepts
> .Add chkEngineering
> .Add chkGraphProd
> ' add other checkboxes
> End With
> End Sub
> --
> Cheers,
> Ryan

check out chip pearson's site
Don't Use The New Keyword In A Dim Statement
http://www.cpearson.com/Excel/variables.htm

--


Gary


"RyanH" <(E-Mail Removed)> wrote in message
news:B76F1E22-740B-4ABF-B8A1-(E-Mail Removed)...
> Can someone tell me the difference in these two subs, if any difference at
> all?
>
> Sub BuildCollections()
>
> Dim colAssignedDepts As Collection
>
> Set colAssignedDepts = New Collection
> With colAssignedDepts
> .Add chkEngineering
> .Add chkGraphProd
> ' add other checkboxes
> End With
> End Sub
>
> Sub BuildCollections()
>
> Dim colAssignedDepts As New Collection
>
> With colAssignedDepts
> .Add chkEngineering
> .Add chkGraphProd
> ' add other checkboxes
> End With
> End Sub
> --
> Cheers,
> Ryan