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...
Results for "fun"
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...
FREE Download : Send Multiple Email Tool – Ver 3.0
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...
Spreading an Array values across Rows in Excel – VBA
This is an extension to my previous Article. Where we learned the best way to spread array values across columns in Excel. Here I will teach you how to spread Array values across Rows in Columns. How it works? How it is different from the previous code? In the...
Spreading an Array values across Columns in Excel – VBA
All my avid readers from Computer Programming backgrounds 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...
HP Quality Center – Excel Macro to Import Test Cases from QC
In this article, I am going to share the VBA code to download the test cases from QC in Excel Sheet. Here in this example, I will fetch very few important fields from QC but if you want more fields to be fetched then it can be easily done. I have categorized this VBA...
HP Quality Center – Check if Connection to QC is made successfully ?
Hello Friends, This article is basically an extension to my previous article How to Connect to HP QC using Excel VBA. As we know, from the previous article that QC Connection is made in two parts: 1. Authentication using QC ID and Password 2. Login with...
Excel Tip : How to save an Excel Addin (.xla) to Excel Workbook(.xls)
Hello Friends, This is a small excel tip to convert a .xla or .xlam file to .xls or .xlsm file. This is a simple trick but really helpful one 🙂 A file with .xla or .xlam extension is an Excel Add-Ins file format which can add new modules, extra functionalities, tabs,...
Email ID Syntax Validation in Excel
Dear LEM users, I got quite a few questions regarding How to enforce Email ID syntax validation in Excel. It could be in a particular cell or any textbox etc. So i thought of putting this small excel VBA tip which may help a lot in enforcing this validation....
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...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
5 very useful and small macros
In the first part of this article, I am going to share very small but useful VBA codes which are most frequently used...
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...
Assign a Shortcut Key using Excel VBA
Dear LEM Readers, In the previous article, you learnt how to assign or modify a shortcut key using excel...