| Sub skinny(ary, Optional base As Long = 0) 'remove empty elements Dim ret() 'return adjustable base array c = base For i = base To UBound(ary) If ary(i) <> " Then ReDim Preserve ret(c) ret(c) = ary(i) c = c + 1 End If Next ary = ret() 'parent ary obj modified and passed back End Sub |
Remove empty elements |
Express News India | Freelance ecommerce web development India