Excel VBA Function

How to Use VBA Array Function in Excel

The Array Function is a very useful tool in Excel to store data and limit the use of the variable, which is basically saving a lot of memory usage of ...

How to Use VBA Space Function in Excel (3 Examples)

In this tutorial, I will explain the details of the excel VBA Space function along with some examples. This function can only be used in VBA code. ...

How to Use VBA Len Function in Excel (4 Examples)

In this article, I will describe the details of the VBA Len function along with some examples. Likewise, excel LEN function, VBA Len returns the ...

How to Use VBA ChDir Function in Excel (4 Suitable Examples)

In Microsoft Excel, it’s easy to change the directory or folder by using VBA Functions. There are a total of nine File/Directory Functions. One of ...

How to Use VBA IsError Function (6 Examples)

There are so many inbuilt functions available in Excel VBA. The IsError function is one of them. This function justifies the given argument and ...

How to Use VBA DateDiff Function in Excel (9 Examples)

In Excel, we utilize numerous functions to do the work speedily and efficiently. Excel VBA also has some built-in functions. The VBA DateDiff ...

How to Use VBA StrComp Function in Excel (5 Common Examples)

In our daily life, we need to compare different things. In Excel, we have some built-in functions to perform this kind of comparison. The StrComp is ...

How to Use IsNull Function in Excel VBA (5 Examples)

Identifying the errors isn't the simplest thing in the world, and spotting them in the middle of a large spreadsheet is nearly burdensome. ...

How to Use VBA Str Function in Excel (4 Examples)

In Excel, we can use various functions to work quickly, and also we utilize VBA to do the work fast. In Excel VBA, there are so many functions that ...

How to Use VBA RTrim Function (5 Suitable Examples)

The VBA RTrim function is a built-in String or Text function in Excel. The RTrim function is only applicable in VBA macros. We can’t use the RTrim ...

How to Use VBA LTrim Function in Excel (4 Examples)

Excel VBA LTrim function removes leading space from a string. This function is used to develop a Macro to remove leading spaces from a specific text. ...

How to Use LOG Function in Excel VBA (5 Suitable Examples)

The VBA LOG function is a built-in Math or Trig function in Excel. The LOG function is available in both Excel Worksheet and VBA however they differ ...

How to Use VBA Abs Function in Excel (9 Examples)

The Abs function is a math function in VBA (Visual Basic for Applications) that returns an absolute value for a number. If you insert a negative ...

How to Use Concatenate in Excel VBA (4 Methods)

In Excel, concatenation is the process of joining two strings together to form a single string. Simply said, if we have a table with first names in ...

How to Use VBA StrConv Function (5 Examples)

VBA StrConv refers to String Conversion; is a String Function used in Microsoft Visual Basic macros. This function changes a given string into a ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo