Hi,

I'm new enough to writing vba for excel.
I'm wondering if there is function to insert a row at the bottom of a range.
I know how to make the range bigger but I'm not sure how to insert an extra row at bottom of the range.

Thanks in advance

Dim NextRow as Long

NextRow = Worksheets("Sheet1").Range("A65536").End(xlUp).Row + 1
Worksheets("Sheet1").Cells(NextRow, 1) = yourData