Latest Posts

AND Function in MS Excel

AND Function: Overview The Microsoft Excel AND function returns TRUE if all logic is TRUE. It returns FALSE if any of the logic is FALSE. AND ...

A detailed analysis of Excel VBA Function Procedure Arguments

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. We knew how to create custom VBA functions and use them ...

How to Execute a Function Procedure

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. We know how to create a macro Sub procedure. Macro Sub ...

How to Create Custom VBA functions and Use them in the Worksheet

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. We already know that there are two types of VBA macros ...

5 Differences Between Subroutine & Function in Excel VBA

There are lots of similarities between a custom Function/User-Defined Function procedure and the Sub-procedure/Subroutine. However, Function ...

A Macro example created using VBA

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. The following is a VBA macro that you can't create by ...

If-Then construct, For-Next loops, With-End With construct, Select Case construct in Excel

VBA uses many constructs that are found in most other programming languages. These constructs are used to control the flow of execution. In this ...

Objects and collections, Properties, Methods, and Variables in Excel VBA

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. Objects and collections VBA is an object-oriented ...

How VBA works in Excel

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. VBA is the most complex feature in Excel. If you have a ...

Excel VBA Coding Tips

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. When you write your VBA code, remember to write it in ...

Writing VBA code in Excel: Entering and Editing code

In our preceding articles, we have demonstrated the easiest way to create simple macros using the macro recorder. To make complex macros, you have to ...

How to Save Macro to Personal Macro Workbook?

In this short article, I will show you how you can save Macro to Personal Macro Workbook. Most macros are created for use in a specific workbook, ...

How to use Relative Reference in Excel Macro (while recording)

In this article, I will show you how to use relative references in Excel Macro while recording. When you’re recording your own macros, you must ...

How to add a macro to your Quick Access toolbar in Excel

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. You can also assign a macro to a button on your Quick ...

How to assign and change a shortcut key to a macro in Excel

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. Assigning a macro to a shortcut key When you start ...

ExcelDemy
Logo