Tags: Array, Dictionary, Exce, Excel VBA Array, Loop, VBA Array
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 :
Tags: Bar Stack Chart, Charts, Chat, Excel, Hierarchy Chart, Stack Chart, VBA
I have customize stack bar chart to a hierarchy chart by using some VBA,
This chart displays the next level data of a selected , user can select a parameter by double click on a series,
you can download .xlsm from here
Note : You can use it with excel 2010.
Thanks for reading
Here is a code to get random list in array, you can pass top and bottom value.