How can I undo changes in cells that had their contents changed by a macro?

that isn't supported. If you really need that capability, you would need to
write code to keep track of the changes and reverse them.

--
Regards,
Tom Ogilvy


"Edson" wrote:

How can I undo changes in cells that had their contents changed by a macro?

Hi Edson,

at the end of procedure changing cell content you can specify using
application.onundo method a procedure that will be run to undo these
changes. Unfortunately you must write this undo procedure yourself. Two
possible ways: keep track of cell values, formulas... or perform
inverse operation (for example: if you inserted rows, you can delete
them with your undo procedure).

Regards,
Ivan