Worksheet_Deactivate procedure leaves me on the deactivated sheet

[carsto]

I have a procedure that Cuts and Pastes any row with a date in Column H on Sheet OPEN to Sheet COMPLETED
It is a Workbook_BeforeClose event

I want to make it a Worksheet_Deactivate event on Sheet OPEN but it always leaves the active sheet as OPEN not the sheet I was trying to activate.

Somehow I need to capture the sheetname of my destination before the procedure runs so that I can end up on the sheet I was actually trying to activate.

I tried this but I endlessly loop the sheet deactivate event though events are turned off in the Sub MoveCompleted.

Private Sub Worksheet_Deactivate()
Destination = ActiveSheet.Name
Call MoveCompleted
Worksheets(Destination).Activate
End Sub

Second question:
Why when you Cut and Paste a row from one sheet to the same sheet , it deletes the cut row, but when you cut & paste a row from one sheet to another sheet, it doesn’t delete the cut row?

[carsto]

bump......