Popular Articles

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

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

Download Free Add-in – File Manager

Dear LEM Readers,   It's been long time since I wrote any article here. I was really busy in some personal work and apology for not making it. Now I am back with some more tutorials, articles, tools and Add-ins.   Here is the first Add-in which I built it for you to make your life easier. I had already [...]

HP Quality Center – Create Folder Structure in Test Lab and Pull test Cases from Test Plan

Dear LEM Readers,   In previous article, we learnt How to connect to HP QC using Excel Macro. In this article we are going to learn How to create folder structure in HP QC Test Lab. As you must be knowing - To show the test execution in Test Lab you should follow below steps:   Step 1. Create folder [...]

How to insert a picture in excel using VBA

Dear Friends, In this article, I am going to teach you a simple VBA code, which help you in inserting a picture in Excel Sheet. I will also discuss about difference between Inserting a picture in Excel and Embedding a picture in Excel Sheet using Excel VBA. It is based on request from one of LEM reader who wants to [...]

Assign a Hot Key to a Command Button in Excel

In Excel VBA you can assign a hot key for a command Button as well. It means you can assign a hot key to a command button which can be triggered by pressing that hot key from the keyboard. It means you can perform the operation either by clicking on the command button or by pressing the hot key.   [...]

Page 2 of 512345