Popular Articles

This is the category all the popular articles are categorized. Interested in reading all the popular reads.. this this the place

Excel Tip : How to Make an Excel Cell secured for Password

One of my friend wanted me to write an article on How can a person achieve making an Excel Cell behave like a password text box which is masked and secured. I have tried to achieve that up to some extent but not 100%. Go through with this article and provide your feedback or suggestion regarding this topic !!. You [...]

Spreading data across Columns in Excel Without VBA Code

In my previous article as you learnt how to split data using VBA SPLIT() function. In this Article I am going to explain you how to separate the data across columns of a cell without excel VBA. Microsoft Excel has a built-in function called Text-to-Columns under Data ribbon (refer the Pic 1). Using this option user can split the data [...]

Read and Write Document Properties of an excel Document – VBA

In this Article we will learn how to get document property of an excel workbook using Excel VBA. Before I jump in to the VBA code let's have a look Where to see document properties in Excel Document? How to see document property of an Excel document Follow the below steps to see the properties for the document: Step 1. [...]

Excel VBA – What is SPLIT Function?

Split is the hardest shot to hit in Bowling. But unlike bowling SPLIT is very simple function to use in excel VBA. Splitting data or string in VBA, sometimes becomes necessary to organize it and to put it in more readable format. SPLIT-function Here in this article, you will learn about splitting the data/string which is joined [...]

Excel OFFSET Function – Excel Tutorial

Dear Friends, What is OFFSET () Function? OFFSET() is a built-in function in excel which returns a range reference which is offset a number of Rows and Columns from a specific Cell or range. Most importantly this is a function which returns Range Address and not the Value. Did you get it what it is used for? No? Don't worry [...]

Excel Trick – Sheet Protection – Protect it and Stay Free

Dear Readers, I am back with another Excel Trick which is very much common while managing your sheet with certain security (protection). To protect the whole Worksheet can be easily done by using the Protect Sheet option available in Microsoft Excel. But in this article I am going to explain you, How to protect your whole sheet except a cell [...]

Excel Trick – SMART Method to make White Background

Dear Readers,   If you are a Microsoft Excel user then you must have come to a situation where you want to show you data in a particular area and rest all the area you want to make it plane white (without lines or grid). Something like depicted in below image: How do we do this formatting GENERALLY? [...]

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

Page 2 of 612345...Last »