Find first blank row

[mark hansen]

I've search for threads containing blank row but I get too many threads containing the words Blanks or row.

I want to put it in a macro to find the first blank row (or last row with data and add one row) to continue with the macro.

As I recall it's something with an xUp command but that's all I remember.

Thanks,
Mark

 

[VoG]

Last used row in Column A:

LR = Range("A" & Rows.Count).End(xlUp).Row

 

[mark hansen]

Thanks for the quick response!!