I didn't see your reply (well, until after I scrolled down).

Tom Ogilvy wrote:

A discussion saying not to DIM as New is found at Chip Pearson's site:

http://www.cpearson.com/excel/variables.htm

it is a little short of 2/3rds down the page:

section title is:
"Don't Use The New Keyword In A Dim Statement"

--
Regards,
Tom Ogilvy

"pacer1" wrote:

Dave your:

If CheckEmpty.Count 20 Then
Set CheckEmpty = New Collection
End If

does exactally what I am looking for. Thanks.

One other quick question. You used:

Option Explicit
Sub CollectionEmptyTry()
Dim CheckEmpty As Collection


Set CheckEmpty = New Collection

Is there any preference over just using:

Option Explicit
Dim CheckEmpty as New Collection

Thanks,

Pace



--

Dave Peterson