UsefulGyaan Has Posted the Following On 06-12-2013 05:10 PM:

Sometimes we need to slice an array i.e. fetch a row/column from a multidimensional array. There is no inbuilt function in VBA to do the same and the most common way to do so is using a loop. However it can be done using a worksheet function named Index. Syntax : * * * * […]

[url=http://usefulgyaan.wordpress.com/2013/06/12/vba-trick-of-the-week-slicing-an-array-without-loop-application-index/]VBA Trick of the Week :: Slicing an Array Without Loop