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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only