Help!
I'm trying to create a macro to cut a row from one worksheet and move it to an archive work sheet.
I've used macro record to cut and past but when I cut and past another row, it wipes out the first one I archived. This is what I have so far
Sub archive()
'
' archive Macro
'
' Keyboard Shortcut: Ctrl+Shift+A
'
Rows("2:2").Select
Selection.Cut
Sheets("Archive").Select
Rows("2:2").Select
ActiveSheet.Paste
Rows("3:3").Select
Sheets("work orders").Select
Selection.Delete Shift:=xlUp
End Sub
Bookmarks