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" wrote in message
...
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