array to range

Excel Macro Beginners – What is Range Object in Excel VBA

Dear readers, Before we discuss the Range Object technically, let us see what is RANGE in excel? In a very simple manner if I define Range, I can say that RANGE is a collections of cells which are in a sequence. This collection can have one or more than one cell. As I have defined, Range is a collection of [...]

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 [...]