title: vba, excel : returning the earliest date value in this array of string
body: <p>i'm having some issues with the coding and not sure where to fix  this:</p>
  
  <p>I would like the BronzeDate to return the earliest date found in my array. </p>
  
  <p>This is examples of the print out:</p>
  
  <pre><code>   Possible Bronze Date : 6/6/2011
     Possible Bronze Date : 10/5/2011
     Possible Bronze Date : 10/5/2011
     Possible Bronze Date : 12/5/2011
     Possible Bronze Date : 10/5/2011
     Possible Bronze Date : 6/6/2011
     Possible Bronze Date : 11/5/2011
     Possible Bronze Date : 1/16/2012
     Possible Bronze Date : 6/6/2011
     Possible Bronze Date : 
     Possible Bronze Date : 
     Possible Bronze Date : 
     Possible Bronze Date : 
     Possible Bronze Date : 
     Possible Bronze Date : 
     Possible Bronze Date : 
     Possible Bronze Date : 
     Possible Bronze Date : 
     Possible Bronze Date : 
    [BRONZE] 0
  </code></pre>
  
  <p>CODING:</p>
  
  <pre><code>    Dim Bronze(1 To 100) As String
  ...
          Dim c As Integer
          c = 1
          Do Until c = 20
              Debug.Print "       Possible Bronze Date : " &amp; Bronze(c)
              c = c + 1
          Loop
  
          '   EXTRACT THE MIN VALUES
          Dim BronzeDate As String
          BronzeDate = Application.WorksheetFunction.Min(Bronze)
  
          '   PRINT OUT VALUE FOR EACH DATES
          Debug.Print "      [BRONZE] " &amp; BronzeDate
  </code></pre>