VBA Trick of the Week :: Slicing an Array Without Loop – Application.Index

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 :   Application.Index(Array, Row_Number, Column_Number) … Continue reading VBA Trick of the Week :: Slicing an Array Without Loop – Application.Index

Useful Gyaan

58 Comments