2 ways
Sub sonic()
row1 = ActiveSheet.UsedRange.Rows.Count + 1
Row = Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Row
End Sub
1st is empty roew and 2nd empty cell coulmn A
Mike
"Anthony B." wrote:
I need help to find the first blank row in column A and need to select
that cell. Any help would be highly appreciated.
AB
*** Sent via Developersdex http://www.developersdex.com ***