Monthly Archives: April 2014

Excel VBA Tip – Expand / Collapse all the Groups in Excel

Dear Readers, This is a small VBA tip to automate to expand or collapse groups created in Excel. Before I jump to VBA code about Expanding or collapsing the groups in excel, I would like to brief you about Grouping or Outlining Functionality in Excel. It is always good to know "How to do it manually. before automating any step. [...]

Things happening AUTOMATICALLY is WOW… but NOT ALWAYS

Well friends before I start my article or tell you what I am going to talk about in this article, How many of you agree with the below incident Once we put some Internet URLs (Website URLS or Email IDs) in a cell it automatically turns in to a hyperlink. There after every time I try to read the whole [...]

FREE Download : Send Multiple Email Tool – Ver 3.0

Dear Readers,   First of all, I would like to thank you all for appreciating and giving the feedback about Send Multiple Email - VBA Tool. I have come up with the next version of the same tool based on your suggestions and feedback. I promise, this version is going to amaze you with it's new properties. I would like [...]

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