Repititive Headers

%3CLINGO-SUB%20id%3D%22lingo-sub-2413219%22%20slang%3D%22en-US%22%3ERepititive%20Headers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2413219%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20created%20code%20and%20it%20worked%20perfectly.%3C%2FP%3E%3CP%3EBut%2C%20i%20have%20pressed%20run%20button%20multiple%20times.%3C%2FP%3E%3CP%3ESo%2C%20what%20should%20i%20write%20to%20revert%20it%20back%20with%20the%20help%20of%20VBA%20code%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help..%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20attached%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2413219%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2414272%22%20slang%3D%22en-US%22%3ERe%3A%20Repititive%20Headers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2414272%22%20slang%3D%22en-US%22%3EActions%20by%20macros%20usually%20cannot%20be%20undone%20with%20undo.%20%3CBR%20%2F%3EClosing%20the%20file%20without%20saving%20may%20solve%20the%20problem.%20If%20you%20have%20the%20file%20stored%20in%20a%20cloud%20service%2C%20you%20might%20be%20able%20to%20recover%20a%20previous%20version.%3CBR%20%2F%3EWhen%20working%20with%20macros%20it%20is%20important%20to%20always%20set%20backup%20copies%20aside.%3CBR%20%2F%3EI%20hope%20this%20answers%20your%20question.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2415170%22%20slang%3D%22en-US%22%3ERe%3A%20Repititive%20Headers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2415170%22%20slang%3D%22en-US%22%3EWith%20the%20help%20of%20VBA%20code%2C%20can%20revert%20it%20back%3F%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I have created code and it worked perfectly.

But, i have pressed run button multiple times.

So, what should i write to revert it back with the help of VBA code?

 

Please help..??

 

Here is the attached file

3 Replies
Actions by macros usually cannot be undone with undo.
Closing the file without saving may solve the problem. If you have the file stored in a cloud service, you might be able to recover a previous version.
When working with macros it is important to always set backup copies aside.
I hope this answers your question.
With the help of VBA code, can revert it back?
Sorry, I don't think so.