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...
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...
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...
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 the...
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...
In the first part of this article, I am going to share very small but useful VBA codes which are most frequently used in day-to-day VBA programming. Many of you had requested them so I have clubbed all of them together and made one article 🙂 Enjoy reading this. Index...
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...
Dear LEM Readers, In the previous article, you learnt how to assign or modify a shortcut key using excel option. In this article you will learn how to assign shortcut keys to your already written procedure or subroutine using VBA (excel macro). At the end of...
Hello Friends, I got many good response on the tool - Send Multiple Email Workbook. I also got a request to implement much other functionality as well. The attachment was one of them. In this version, I have added the attachment functionality with some other small...
Dear Readers, In my previous article, you saw how to save an Excel Sheet as PDF file. Now you know, how to save an Excel Sheet as a pdf. Also, we have seen how to send the ActiveSheet as an attachment in Email. In this article, I am going to show you how to send the...
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.
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 (=).
![40 Useful Excel Macro [VBA] examples – Part 2 of 2 [ FREE DOWNLOAD ]](https://vmlogger.com/excel/wp-content/uploads/sites/11/2018/06/40-useful-vba-codes-400x250.png)
Dear friends, As you see this is the second and last part of the tutorial 40 Useful Excel Macro [VBA] examples. In a...
![40 Useful Excel Macro [VBA] examples – Part 1 of 2](https://vmlogger.com/excel/wp-content/uploads/sites/11/2018/06/40-useful-excel-vb-code-2-1-400x250.png)
Dear Friends, Here in this article, I have tried to consolidate some most useful and more frequently used excel macro...
![Send Multiple Emails Tool – Ver 4.0 [Imp Bug fixes]](https://vmlogger.com/excel/wp-content/uploads/sites/11/2016/12/2016-12-30-69558_400x250.png)
Dear friends, The version of Send Multiple Emails Tool, I released last, there was a small issue with the mail sent by...
