undo execute after macro

[j_r_m_c]

i have a macro to insert a new row and copy formula, from the row above
but if i do a mistake, the undo is not possible
why?

the macro is this one

Please Login or Register  to view this content.

[j_r_m_c]

after search i reach the conclusion that its a excel problem
and there is nothing to do

[shg]

That's correct, once code modifies anything on a worksheet, the Undo capability is gone. It's a good reason to think hard before using VBA.

[TMS]

I don't think it's a problem ... I think it's by design.

If you consider what a VBA macro can be made to do, it would be impossible to keep track and undo everything.

Regards

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[royUK]

See John Walkenbach's suggestion