Transformer
06-12-2013, 04:40 PM
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 : * * * * […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=942&subd=usefulgyaan&ref=&feed=1
[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
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 : * * * * […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=942&subd=usefulgyaan&ref=&feed=1
[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