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...
Results for "cell"
What is Pivot Table ?
As you know Excel has so many excellent features in it. Pivot Table is one of them. If you use Microsoft Excel and not used Pivot Table, It means you have missed a really great feature of Excel. Pivot table is the best tool available in Excel to Sort, Filter, Count,...
Excel Formula : DATE and TIME Formula
Want to know about most of the Important Formulas in Excel? Read Excel Formulas Tutorial Page. Click on the below links for to know about all these Formulas and how to use them DATE | DATEDIF | DATEVALUE | DAY | DAYS360 | HOUR | MINUTE | MONTH | NOW | SECOND |...
What is Excel Formula ? How to use Excel Formula?
This Article is written for the people who does not know about Excel formula. This article answers following questions about Excel Formulas: 1. What is Excel Formula? 2. How to Use Excel Formula - a step by step tutorial. 3. How an Excel Formula works in Excel?...
Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding)
Let's take a brief recap of all things you have studied so far in Excel Macro Tutorial. So far you have learnt so many basic stuffs about Excel Macros under Excel Macro Tutorials. You have learned about all the Controls available in Excel Macros and also how to use...
How to get Excel Range in Array
Many times while developing an application in Excel VBA, we need all the values stored in an excel Cell Range in an Array variable. So that at any point in time we can access the value from the array, rather than going to Excel Cell and reading it from there. Also,...
Assigning Macro : How to assign macro to Hyperlink ?
So far we have always seen running any Macro or Function using a Command Button. Sometimes, instead of putting a Command Button, you want to do the same operations but by using a Hyperlink in Excel. In this article, you are going to learn how to run a macro by using...
User Defined Function in Excel to Convert Currency to Words
Many times we require to change the Numbers in Words. For Example 6734862=Sixty Seven Lakhs Thirty-Four Thousand Eight Hundred Sixty Two. In Excel, there is no Formula as such to Convert Numbers into Words. I have written one UDF : User Defined Function. After using...
Excel Macro Tutorial : How to Use ListBox in Excel
As we saw in the Previous Article you learnt How to use Drop Down Box in Excel If you want to read more about Excel Macro... visit Excel Macro Tutorial In this Article you will learn How to Use ListBox in Excel. It will include 1. Adding Items in...
Excel Macro Tutorial : ComboBox in Excel Macro
It's been a long time since I posted an article :(. Today I am going to write about Combo Box in Excel. At the end of this Article, you will be able to use Drop down in Excel. It will include 1. Adding Items in Excel Combobox dor Excel Drop Down 2. Removing...
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...