Excel VBA Function

How to Unhide Top Rows in Excel (7 Methods)

To unhide the hidden rows or columns is very common in Excel files. We hide rows or columns intentionally. So, the viewers can not see the ...

How to Remove Duplicates in Excel Sheet (7 Methods)

Duplicates in Excel worksheets are a big issue for the users. It is very tiresome work to find duplicates and remove them. In this tutorial, we will ...

Excel Date Picker for Entire Column

Date Picker is one of the interesting tools of Microsoft Excel. It relieves us from the monotonous work of inserting data for each cell manually. ...

Excel Formula to Generate Random Number (5 examples)

A random number is not necessary for all users of Microsoft Excel. Most of the users use fixed numbers to perform any operation in Excel. But when we ...

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 Switch Function (6 Suitable Examples)

The Switch function is Microsoft Excel’s in-built function. It is used in Excel VBA too. The working procedure of this function is quite interesting. ...

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 in Excel (5 Common Examples)

In our daily life, we need to compare different things. In Excel, we have some inbuilt 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 While Wend Statement in Excel (4 Examples)

The While…Wend Statement is a logical function in Excel VBA. The statement is used to create a While loop. When you are uncertain about the necessity ...

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 ...

ExcelDemy
Logo