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

Excel Macro Tutorial : While Loop and Do While Loop in Excel VBA

In previous Article, we had seen about For Next Loop. In this article we are going to see about While and Do While Loop. While Loop Do...While Loop While Loop: Syntax: While [condition] [statements] ............ [statements] Wend Example: Let's take the same example what we discussed in previous Article with For..Next Loop.. Calculate the Sum of all Numbers from 1 [...]

Excel Macro Tutorial : For Next Loop in Excel Macro

Beginners guide for how to use FOR Loop in Excel VBA Keeping the beginners in mind, I am going to write this article about For Next loop in Excel Macro. Also one of my friend wanted such post to be published. First of all i would like to thank for such input and feedback. Even if you want any help or [...]