![]()
Sub copyrow() Set wb = ThisWorkbook Set wbdev = Workbooks.Open(wb.Path & "\Devicess.xlsx") Sheets("Data").Select lr = Cells(Rows.Count, "A").End(xlUp).Row + 1 wb.Sheets("Email Data").Range("A9:L9").Copy Cells(lr, 2) Cells(lr, 1) = Date End Sub
![]()
Sub copyrow() Set wb = ThisWorkbook Set wbdev = Workbooks.Open(wb.Path & "\Devicess.xlsx") Sheets("Data").Select lr = Cells(Rows.Count, "A").End(xlUp).Row + 1 wb.Sheets("Email Data").Range("A9:L9").Copy Cells(lr, 2) Cells(lr, 1) = Date End Sub
If solved remember to mark Thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks