title: Skip Double Comma in Split Function
body: <p>My String (strSQL) Value is 1,2,3,,4 and My result shows blank between 3 and 4 due to Double comma (,,). My Code is Following:-</p>
  
  <pre><code>strParts = Split(strSQL, ", ")
          For intCounter = LBound(strParts()) To UBound(strParts())
              Me.Controls("cmd" &amp; intCounter).Visible = True
              Me.Controls("cmd" &amp; intCounter).Caption = strParts(intCounter)                
          Next intCounter
  </code></pre>