I need help with a procedure I'm trying to run in Excel. First I'm using AutoSave in Excel (I need something automated) I want to do a simple Cut and Paste before Excel save my Workbook. Here's the code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Range("A1").Select
Selection.Copy
Range("A13").Select
ActiveSheet.Paste

End Sub

It seems to work only when I CLIC on Save but not when it's on AutoSave. I need a solution working with AutoSave.

Thanks

Richard

P.S. Thanks for the help, Éric