View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dick[_2_] dick[_2_] is offline
external usenet poster
 
Posts: 6
Default collection usage/syntax please

What is the proper syntax for the collection statements in the
following pseudo code:

Dim C as Collection

Loop over cells in a range:

C = New Collection [or is it Set C =.....]

LoadC ( C , cell from Loop)[will add item to collection]

UseC (C) [will use or do something with the collection]

C = Nothing [is this proper, all examples use a Remove]

Next Loop over cells

Thanks.