VB Command to move cursor to first empty row of table
Posted on 2014-02-13
I am recording an Excel macro and need it to select the first empty field at the bottom of a particular column. The number of rows in the column will vary every time I run the macro.
I've figured out a way to have the macro move to the last row of data of the column with this command:
If column F has 8 rows of data, the above lands me on F8. But I then need to move the cursor down one more row to F9. When I use the macro recorder, Excel records a literal address of F9 like this:
But the next time I run it column F might have 10 rows of data. What command do I use to move down one?