Hi All,
I'm trying to add a line to this macro:
I cannot work out how to do the bit in red. Can anyone assist?![]()
Sub AddNewProject() Dim LastRow As Integer LastRow = Range("A65536").End(xlUp).Row Range(LastRow:LastRow+7).Copy End Sub
Thanks
dvent
Bookmarks