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...
Results for "while"
Spreading an Array values across Columns in Excel – VBA
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...
HP Quality Center – Create Folder Structure in Test Lab and Pull test Cases from Test Plan
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...
How to insert a picture in excel using VBA
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...
Check if file is already open using excel VBA
Dear LEM Readers, While doing programming with VBA many a times it happens to open an existing file. Before opening that file, it is always a good idea to check if that file is already open or not. Therefore I have written a function (IsFileOpen()) which takes...
How to assign a Shortcut key to a Procedure or Subroutine
Dear LEM (Learn Exel Macro) Readers, It's been long time I wrote any article or answered any of your queries. Apologies for the delay in response. I am back with many more amazing articles now. All your un-answered questions will be answered in few days with a set of...
Get Special Folder Path using VBA
Hello Friends, In this article I am going to explain you how to get the path of Special Folders in Windows Operating System. Using VBA we can get path of Special folders path like, Desktop, My Documents, Library etc. Few important special folders are listed below....
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 certain reports in an Excel Sheet but while sending that report to your boss, you want that to be saved in a PDF form. In such case you can simply...
How to insert Outlook Signature in Email by Excel VBA
In this Article you are going to learn how to insert Outlook Signature in outlook email while sending an email via Excel VBA. It means while sending an email from Outlook via Excel Macro, if you want already saved signature to be inserted at the end of your email,...
Excel Formula : MATHEMATICAL Formulas
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 ABS | CEILING | COMBIN | COUNTIF | EVEN | FACT | FLOOR | INT | MINVERSE | MMULT |...
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 (=).
Excel OFFSET Function – Excel Tutorial
Dear Friends, What is OFFSET () Function? OFFSET() is a built-in function in excel which returns a range reference...
Excel Trick – Sheet Protection – Protect it and Stay Free
Dear Readers, I am back with another Excel Trick which is very much common while managing your sheet with certain...
Excel Trick – SMART Method to make White Background
Dear Readers, If you are a Microsoft Excel user then you must have come to a situation where you want to show...