Latest Posts

An Excel VBA function with a range argument

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. Well, the last type of argument is a range. It is ...

An Excel VBA function with two arguments

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. In this example, I am going to write a VBA function that ...

How to Use Excel VBA User Defined Function in Formula

Excel VBA provides two procedures. One is functions also known as the user-defined functions another one is subroutines. In this tutorial, I am going ...

What is an Argument in Excel with Example

Excel has many functions for different operations.  Inside the parenthesis of the functions, we put some inputs for the desired operation that we ...

LARGE function in Excel

LARGE Function: Overview The LARGE function in Microsoft Excel returns the nth largest value from a data range. LARGE function: Syntax  LARGE ...

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

The following is a VBA macro that you can't create by recording. It uses programming concepts that must be entered manually. This macro shows a list ...

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

When you write your VBA code, remember to write it in such a way that any other user can easily read and understand your code. Even after some ...

ExcelDemy
Logo