array

Spreading an Array values across Rows in Excel – VBA

Hello friends,   This is an extension to my previous Article. Where we learnt a best way to spread an array values across columns in Excel. Here I will teach you how to spread an Array values across Rows in Column. How it works? How it is different from the previous code? In the previous code there are TWO changes [...]

Spreading an Array values across Columns in Excel – VBA

All my avid readers from Computer Programming background must be thinking is it a big deal? Like other programming languages use loop to traverse all the values of an array and spread them across rows or column. Right?   If you are thinking so... you are absolutely right. You can do it using loop.   But what if I tell [...]

How to get Excel Range in Array

Many a times while doing coding in excel, we need all the values stored in a Cell Range in an Array format. So that during any point of time we can access the value from the array, rather going in Excel Cell and reading from there. Thinking that in mind, I just created a Function (UDF - User Defined Function) [...]