Vba range how many rows

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services.

Privacy policy. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. The macro also returns the answer in a message box. However, you may find it inconvenient to have to manually select the entire list before running the macro. Unlike databases tables such as Access , Excel tables are not always continuous. However, this causes an additional challenge when we try to find the actual number of populated rows in a worksheet with VBA.

There are some empty rows e. We want to use VBA to find:. Count number of characters in a cell. How to count the total number of characters, including spaces, in a cell using Excel and VBA methods. Count number of characters in a cell excluding spaces. How to count the total number of characters in a cell, excluding spaces, using Excel and VBA methods.

Output: Same as the first image in this article. This piece of code can help to find the number of rows that are in the used range of a sheet. Similar to the above code, here is another code snippet that counts the number of columns within the used range of a sheet and displays the result in a message box. This is a built in function offered by VBA. It returns a range object which represents only specified types of cells.

In this program there is an Excel sheet with the principal amount, number of years, and age of the customer in different columns of the sheet. We need a program that does not use formulae. The simple interest and maturity amount should be calculated for each row but we do not know how many rows of data are there in the sheet. So, here, used range property is used to fetch the last row number.

Then you can use a for loop to iterate through each row, do the calculation, and enter the result in a different column of the same row.