I want to be able to find the first blank row in a spreadsheet then copy the properties of the previous row into that new row (i.e. formulas, validation ,etc.). I started with this (just picking any source row) then realized that that would do every row in the spreadsheet!

For MY_ROWs = 6 To Range("A65536").End(xlUp).row

If Range("A" & MY_ROWs).Value = " " Then

Rows("6:6").Select

Selection.Copy

MY_ROWs.Select

ActiveSheet.Paste

Range("A" & MY_ROWs).Select

Next MY_ROWs

End Sub

As an added bonus the first column has an incremental number which is cell C3+ a number (i.e. If C3 = 1501-421 then Column A is 1501-421-1, 1501-421-2, 1501-421-3, etc.)

I'd be happy just to get the first part done then I could add a prompt telling the user to add the new number. But any help is appreciated.