Excel Tutorials - Page 4 of 12 - Tips, Solutions, Tricks

VBA Sum Function [Ranges, Variables, Numbers]

The Excel SUM function can be used in VBA by WorksheetFunction object.

VBA IsNumeric Vs IsNumber [Compared with 4 Examples]

IsNumeric is the VBA function that you may use directly. IsNumber is the Excel function that you may use in VBA. However, you have to use this with Application.WorksheetFunction object.

Create 3-D Column Charts in Excel

Alternatively, you may go to “Recommended Charts” and in the dialog box, click “All Charts”.

Visual Basic for Applications (VBA) CountIf Method Illustration

Excel / VBA CountIf Method with 7 Examples

The COUNTIF is an Excel function that you may use in VBA as well. For that, you may use the WorksheetFunction object’s CountIf method.

VBA Max Function

The Max() is WorksheetFunction that you may use in the VBA coding to get the maximum number.

It takes up to thirty arguments i.e.

Pandas to_excel: 5 Examples of Data Frame to Excel

Similarly, it has to_excel method that can be used to write data in an Excel file. Once you have data frame, it can be stored as Excel file (.xlsx).

4 Examples to Learn VBA Mod Operator

To get the remainder of a division, you may use the Excel/VBA Mod operator.

VBA UBound and LBound Functions

UBound and LBound are array functions in VBA. Let us look at these, one by one.

Deleting Empty Rows in Excel by Shortcut (3 Steps)

In this tutorial, we will show a three steps process of removing all empty (adjacent or non-adjacent) rows in Excel – by using a shortcut.

3 Examples to Create Clustered Bar Charts in Excel

Go to Insert in the ribbon and click on “Recommended Charts”

Excel/VBA Now() function: Get Current Date and Time

The Now() function returns the current date and time from the computer system. It returns variant (Date).

VBA Integer Vs Long Data Types: Explained with 6 Examples

In VBA, there are a few numeric data types that you may use to handle numbers in your applications. Out of these, Integer and Long deal with signed numbers.