In this article, you will learn how to find the next row using VBA.
Let us understand with an example:
Following is a snapshot of Sales Report wherein the next row after the last row can be identified as 11.
In case the user is working on large amount of data & multiple workbooks then, it becomes harder to manually figure out; we need VBA code to help us.
Click on Developer tab
From Code group, select Visual Basic
or press ALT + F11 shortcut key to launch VB Editor screen.
Click on Insert, and then on Module
This will create new module.
Enter the following code in the Module
NR = ThisWorkbook.Sheets(“Sheet1″).Cells(Rows.Count, 1).End(xlUp).Row + 1
MsgBox “The next row is “& NR
The result will be shown through Message Box
In this way, you can get to know the next available row of the worksheet using VBA code & now, we can use this code in writing larger codes for automation purpose.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.