About Microsoft Excel

A useful macro to find the next empty or blank row in an Excel worksheet

Excel 2007
Excel 2003
Macros Excel 2007
Macros Excel 2003
Excel 2010

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.




Further reading
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010