How to count non-empty rows in Excel VBA?

Use the following VBA code to count the number of non-empty rows in a worksheet. This includes empty rows which contain no data, as well as those that have values in any of the columns. The code uses the IsEmpty property of a cell to check whether a cell contains a value or not. This method returns True for cells containing formulas and empty values. An empty value is a value that consists of only spaces or blanks

How to count used rows in Excel VBA?

Using the example of the UsedRange property, to count the number of rows in the worksheet you should use the following line of code:

How to count non-empty rows in Excel?

There are two ways to count the non-empty rows in a range. One of them is to use the CountA property. It returns the number of cells that are not empty in a given range. The other method is to use the UBound function. It returns the upper bound of the last row returned by a given range.

How to count non-empty cells in Excel VBA?

If you want to count the number of non-empty rows in a given worksheet (or a worksheet range), use the WorksheetFunction.CountA method. The syntax is:

How to find non-empty rows in Excel VBA?

Using the Rows.Count property, you can determine the number of rows in a worksheet. This property returns an integer value. If you want to find the number of rows that contain data, use the method Tristate IsEmpty. The Tristate IsEmpty function returns True if the cell or range is empty, meaning the cell contains no data.