Hello everybody
I have this code
The macro called (ClearRange) to clear the range A1:C10 >>Sub CloseMe() Application.OnTime Now + TimeValue("00:00:10"), "OpenMe" Savechanges = False ThisWorkbook.Close False End Sub Sub OpenMe() MsgBox "Data Restored" End Sub Sub ClearRange() Range("A1:C10").ClearContents Range("A1").Select End Sub
The macro called CloseMe have to restore data after 10 seconds
When I run CloseMe I encountered an error messgage (Excel has stopped working) .. Check online for a solution....
What is the problem with the code?
Bookmarks