Convert Specific formula to value :


Many times i have seen this query on Excel discussion groups and forums to convert values for a specific formulas on worksheets. so i have decided to post a something about that. it might be little helpful for Excel users. here is a code which will convert formulas to values on every sheets, this code…

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…

Exclude Contents From List :


Hi, What would be your approach to do this job ūüôā¬† Suppose you have 2 List As showing below , and you need to remove List2 contents from List 1 , here is better code to accomplish this job , By using dictionary i just tried to make this process fast ūüôā Sub ExcludeFromList() ¬†…

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…

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…