Array Class


Although VBA is a great language to manipulate office objects accordingly, but when it came to array handling  there are lack of method to handle array, To resolve some of problems i collect and create some method and properties, see the content listed below which you can find in the class module . Functions available…

Get Random List :


Here is a code to get random list in array, you can pass top and bottom value. Function GetRandList(ListCount As Long, Bottom As Long, Top As Long) As Variant     Dim lngCOunt As Long     If Bottom < Top Then         With CreateObject(“Scripting.Dictionary”)             Do While…