Dear Friends, Couple of my friends asked me about this like how can I send screenshot of a particular range area of my excel sheet embedded in my HTML mail with other texts in my email. I also got this question on Microsoft Excel forum where I answered that question...
Results for "list"
Contact Me
I am still available on this planet earth and can be easily contacted. I can be contacted for business, learning as well as socialising purposes. For faster response contact me on twitter, facebook or instagram
Invoice Template [ FREE Download ]
Hello friends, There are many small businesses which are using Excel for their day-to-day management. Like Generating invoice, quotation, tracking data about customers, sales, employees etc. In nutshell complete management is done in excel spreadsheets. I manage my...
Excel Tip: How to refer characters using ASCII Value
Hello friends, In this article, I am going to explain you, how can you use special characters in Excel VBA and formulas without breaking the syntax. For Example: You can not use double quote or any other Special Characters, which are generally a part of Formula...
Complete VBA tutorial to interact with Power point Presentations – Part – 2 of 2
This is a continuation of my previous article about Interaction with Power point Slides using Excel Macro. In my previous article we learn how to create a New Power Point Presentation using Excel Macro (by creating Power Point Object). Bit of a Story about this...
Complete VBA tutorial to interact with Power point Presentations – Part – 1
[fusion_text] ear Friends, First of all, I apologize for not responding to many of your questions around dealing with PowerPoint presentations through Excel Macro. Many of you have sent me so...
Spreading data across Columns in Excel Without VBA Code
In my previous article as you learnt how to split data using VBA SPLIT() function. In this Article I am going to explain you how to separate the data across columns of a cell without excel VBA. Microsoft Excel has a built-in function called Text-to-Columns under Data...
Read and Write Document Properties of an excel Document – VBA
In this Article we will learn how to get document property of an excel workbook using Excel VBA. Before I jump in to the VBA code let's have a look Where to see document properties in Excel Document? How to see document property of an Excel document Follow the below...
Create UDF in Excel in 4 Steps – Your Own Excel Formula
ser Defined functions (UDF) is also known as Custom Functions (formulas) in Excel. So far, I have created many different User Defined Functions for different purposes but never told you about How to create Custom Functions in Excel in a systematic...
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...
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 (=).
Calculate distance between two places in Excel [With Fun]
Dear readers, Last week, I had placed an article on how to create a static google map in excel using Google Static Map...
Excel Tool : Folder Structure Creator
Dear readers, In my previous article I posted an article about how to create folder in windows by Excel VBA code. That...
Invoice Template [ FREE Download ]
Hello friends, There are many small businesses which are using Excel for their day-to-day management. Like Generating...