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...
Results for "column"
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...
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=""...
References In Excel Formulas – Absolute and Relative
This article is not about Excel Macro but this is about Absolute and Relative References in Excel formula. In Excel Formulas, as you have seen, for referring any cell, we use the Address (Reference) of that Cell like A1, B2 etc. This is called Cell Reference in Excel....
How to Send an Email using Excel Macro from Gmail or Yahoo
Dear Readers, In this article, we are going to learn how to send an email automatically by Excel Excel VBA. While executing the Excel Macro, sometimes you may need to send some Details or Results directly to your email ID or any other ID using Excel Macro. If you have...
Conditional Formatting based on Condition in other Cell
In previous post we saw the normal conditional Formatting. It means based on the condition of a cell, changing the format of same cell is normal conditional formatting. But here we are going to see the conditional formatting of a cell based on some other cell...
Conditional Formatting in Excel
Conditional Formatting in Excel: In MS Excel we can do formatting of cells based on some conditions or values. This is called Conditional formatting. For example, if you want a cell color to be red whenever the Value in the Cell is updated as "FAILED" or "Less Than...
Sorting a String stored in a cell of Excel
Dear Readers, By using Excel Macro, we can sort a String which is stored in a Cell in an Excel Sheet. Sorting will be done as a String. For example (Ascending): First all Numeric Values in ascending Order then Special Chars then Alphabets in ascending etc. For this we...
List All files from Folder and Sub-folders in Excel Workbook
In this article, we are going to learn about how to list the files from folders. Here we will also learn how to list files from subfolders as well. By using File System Object, we can get the list of all Files inside a folder. An important thing to note here is that...
Sorting using Excel Macro
Sorting in excel sheet, is a very common functionality. Most excel users should be knowing already. But here we are going to learn how to do sorting using Excel VBA. If you are working on any automation in excel, it will be useful to know. You might want to provide...
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...