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 in My Class Module for array handling .
|Function Name||Description||Return Type|
|Function Offset||By This Function You can Extract any Part of an Array.. It works like Excel Offset function||Array Class Object|
|Function FilterArray||as name implies , you can Filter array by this function||Array Class Object|
|Function Sort||You can sort an array . ACS and DESC order||Array Class Object|
|Function IsArrayFilled||you can check weather array is empty or not||True/False|
|Function IsArray2Dimensional||Return True if array is 2 D||True/False|
|Function CombineArray||Most Important Function to Combine Two Array, Either by Rows or Columns||Array Class Object|
|Function Rows||you can Extract a particular Row from an Array||Array Class Object|
|Function Columns||you can Extract a particular Columns from an Array||Array Class Object|
|Function Transpose||Just Using Normal VBA Transpose Function to Transpose Array. Limited as VBA Transpose||Array Class Object|
|Function GetUnique||You can Get Unique Array List by this Function||Array Class Object|
|Function CopyFromRecordset||you can assign an Object input Array from a Recordset||Nothing|
you can find some properties of an Array object’s Listed below :