Extract Array Elements :


Extract Array : Here is a technique to extract a particular column or Row from a 2D Array ‘============================================================================== Sub TestOnArray()     Dim VarArr     Dim VarArr2     Dim VarArr3     Dim blnFilter As Boolean         Application.EnableEvents = False     VarArr = Range(“Range”)     VarArr2 = Application.Index(VarArr, , Range(“rngCol”).Value)     Range(“rngOutput”).CurrentRegion.ClearContents     If Range(“rngCol”).Value…

Split Data into Multiple Workbook


Hi, Many times we need to make category wise separate files  from data on a worksheet, here is code that will do it for you. Here i have a scenario ,Suppose  we have some data in a Range and 2nd Column of Range have some Categories , we want to bifurcate all Record of all Categories in different Excel…