Hi All,

I'm trying to add a line to this macro:

Sub AddNewProject()

Dim LastRow As Integer
LastRow = Range("A65536").End(xlUp).Row

Range(LastRow:LastRow+7).Copy

End Sub
I cannot work out how to do the bit in red. Can anyone assist?

Thanks
dvent