how to safe UNDO list

  • Thread starter Thread starter Boris Stumpf
  • Start date Start date
B

Boris Stumpf

Hi newsgroup,

after each changing in a worksheet, a macro ist runing.
My problem is, the UNDO list is deleted after running a macro.
i'll like to use the UNDO funktion, after the macro.
Is it possible to safe the statments in my undo list befor running the
macro, an to safe it back after.

Thanks;
Boris
 
Boris
No. That is lost forever. What you can do is to add code within your
macro to capture the data before the macro changes it. You can have the
macro put that data in some out-of-the-way place in your sheet or in another
sheet or you can create a sheet expressly for that purpose. Then you can
access that data as you wish. HTH Otto
 
Back
Top