How to Name Range in Excel: Hello Friends, It's been long time, I did not post any Article. So today I thought of writing one Article on one of the most useful features in Excel. I am talking about the Ability to Provide meaningful name for various items or Cell...
Results for "time"
Shortcut Keys in Microsoft Excel
Hello Friends, Here I am going to list down some useful Shortcut Keys. These keys are very useful in your day to day excel use. By making these shortcuts in practice you can do many of the things in Excel Easily. Key Description CTRL+( Unhides any hidden rows within...
Excel Macro Tutorial : Toggle Button in Excel
Some times, we require a single control or Button which can perform different action on first click and some other Action on the second click. This can be achieved by adding Toggle Button in your Excel Workbook. How to Add Toggle Button in Excel Workbook: It's very...
How to Send ActiveWorkbook as attachment in Email
In previous Article, i had written how to Send Email from Excel Macro. In that article we had discussed how we can send any random file as an Attachment. Here in this article, you will learn how to send the ActiveWorkbook as an attachment. There could be two ways of...
Excel UDF: To exctract All Numbers, Special Characters and Alphabets from a String
Sometimes you require to Extract All Numbers and Characters from a mixed String. I have written a UDF (User Defined Function) to extract them. UDF Function to Extract Numbers from a String UDF Function to Extract Special Characters from a String UDF Function to...
How to format whole row or a Range by Conditional Formating
Sometimes in Excel, we need auto-formatting as soon as a condition in a particular cell or cell range is satisfied then the formatting of the whole row or a cell range should change. This is very easy to do in Excel by using Conditional Formatting. Let's take an...
Step by Step tutorial for While Loop Excel VBA
In previous Article, we had seen about For Next Loop. In this article we are going to learn about While and Do While Loop. While loop is also quite useful in Excel VBA programming. Here in this article, I will explain each and every aspect related to While loop with...
Excel Macro Tutorial : For Next Loop in Excel Macro
[fullwidth background_color="" background_image="" background_parallax="none" enable_mobile="no" parallax_speed="0.3" background_repeat="no-repeat" background_position="left top" video_url="" video_aspect_ratio="16:9" video_webm="" video_mp4="" video_ogv=""...
How to compare two columns in Excel to find duplicates
Many times we require to compare two columns' data and find out all the Duplicates. So in this article, you are going to see how we can compare two columns in Excel and find out duplicates. There are two ways of comparing two columns in an Excel Worksheet. 1.By Using...
How to interact with HTML pages from Excel
In this article you are going to learn how to interact with HTML pages from Excel Macro/VBA. Though Excel is not much capable and easy enough to interact with HTML pages and its HTML controls. But up to some extend we can interact with HTML pages by Excel Macro. To...
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 (=).
Download : Excel Macro Application to Send Multiple Emails – 2.0
Hello Friends, I got many good response on the tool - Send Multiple Email Workbook. I also got a request to implement...
Send Sheet as a PDF attachment in Email
Dear Readers, In my previous article, you saw how to save an Excel Sheet as PDF file. Now you know, how to save an...
How to Export an Excel Sheet as PDF file
Dear Readers, In this article you are going to learn How to save an Excel Sheet as pdf file. Many a times we generate...