A useful macro to find the next empty or blank row in an Excel worksheet
Let’s say you wish to calculate and then transfer data from a userform via a macro to an Excel worksheet. The first step involves finding out where the next empty or blank row lies. In our example we have a database already in place with the titles ‘Item’ and ‘Unit’. We have described how you find out the next empty row for data entry using a macro. The macro gives a message with the empty row number. Based on this information you can build a more detailed userform as shown in the next training videos.In an earlier example we had described how to achieve the same thing using the offset property.
View the training video: