IsArrayFilled


Function IsArrayFilled(InputArray As Variant) As Boolean     ‘================================================     ‘       this function check Array filled or not     ‘                    ParameterInfo     ‘       InputArray   :   Array you want to check     ‘================================================    …

Check Array Dimension


  Function IsArray2Dimensional(InputArray As Variant) As Boolean                ‘================================================     ‘       this function check is Array 2D or not     ‘                    ParameterInfo     ‘       InputArray   :   Array you want…

Sort 2D Array


 Hi All,   You can use this function to Sort 2D Array, either ascending or descending on selected column , See the MTest Macro to test the code ‘============================================================== Option Explicit Enum SortType     xlAscending     xlDescending End Enum Function BubbleSort(InputArray As Variant, Optional SortColumn As Integer = 1, _            …

Check String Case


Hi All, You can use this function to check the case of a string. Function CheckCase(rngDta as Range) As Byte ‘======================================================== ‘How this Works ‘Pass a string argument to check the case of string ‘it would Return 1 in case of UpperCase ‘it would Return 2 in case of ProperCase ‘it would return 3 in case…

Extract Subset of an array


Hi All, As you know array is extremely faster then working on a range, in some scenerio we need to extract a subset of a range,here is a function to get a subset from a multidimension array, instead of using range you can get the subset from an array, see the tested code below this…

VlookupArray


Function VlookupArray(Lookup_value As Variant, Lookup_Array, Column_number As Long) As Variant          Dim blnFlag As Boolean     Dim VarCol     Dim lngIndex  As Long          ‘==============================================================     ‘Created by Rajan on 14-July-2012     ‘ParameterInfo     ‘Lookup_Value   : Value what you find in the first…

Remove Contents From String:


This function use regular expression object to remove unwanted contents from a string, so you can use this to remove Text,Numeric or other special character defined in Pattern of this function Enum WhatToRemove Text Numeric SpecialCharacters End Enum Function RemoveContents(StringToReplace, WhatRemove As WhatToRemove) As String Dim RegEx As Object Set RegEx = CreateObject(“VBScript.RegExp”) With RegEx…

Filter Array : Revised


Here is an faster and easier way to filter 2D Array Syntex to Use : FilterArray InputArray, ResultArray, FilterColumn, FilterValue, FilterType                 ============================================================================== Enum Combination     xlRow     xlColumn End Enum Enum FltType     xlFilterEqualTo     xlFilterLessThen     xlFilterLessThenEqualTo     xlFilterGreaterThen     xlFilterGreaterThenEqualTo     xlFilterDoesNotEqualTo     xlFilterContains    …

Filter 2D Array [Rows and Columns]


Hi, Here is a function to filter 2D Array either by Rows and Columns. Syntex: FilterArray InputArray , ResultArray , 1 , “Product1”,xlFilterDoesNotEqualTo Suppose you have An Array of Sales Data of Multiple Product , but you need to retrieve data only for one product in another array, Use this 🙂 ================================================================================ Enum Combination    …

Hello world!


Welcome to WordPress.com! This is your very first post. Click the Edit link to modify or delete it, or start a new post. If you like, use this post to tell readers why you started this blog and what you plan to do with it. Happy blogging!

Fill Array One D to Two D


Below function used to fill one dimensional array elements to 2D Array based on Given parameters, ================================================================================================================================== Enum Combination     xlRow     xlColumn End Enum Enum FillType     FillRowWise     FillColumnWise End Enum ================================================================================================================================== Function JustifyArray(varArrInput As Variant, VarArrResult As Variant, TransformIn As Combination, HowMany As Long, HowToFill As FillType) As Boolean           …

Combine Array Elements [Rows or Columns]


here is an updated version of my last  function to combine arrays elements. by using this function user can combine columns as well as rows also ,  Enum Combination     xlRow     xlColumn End Enum Private Function CombineArrayCol(ArrFirst As Variant, ArrAdd As Variant, ArrResult As Variant, CombinationOf As Combination) As Boolean    …

Function to Combine Array


Hi All, Here is a function to combine an array columns in another array. Private Function CombineArrayCol(ArrFirst As Variant, ArrAdd As Variant, ArrResult As Variant) As Boolean              ‘Created By Rajan 4-July-2012          ‘———How to Use——————-        ‘Syntex        ‘CombineArrayCol FirstArray ,SecondArray ,ResultArray                ‘   FirstArray =…