Take a look he

http://j-walk.com/ss/excel/tips/tip23.htm

In article ,
sameerce wrote:

Hi,
I have made a Excel VBA based application where in I have some features
where I insert rows and assign formulas for the new rows by means of
VB. But, the problem is that once the new rows and formulas are
inserted, I am not able to undo the changes.

Can anyone please tell me if there is a way to undo the changes made
either directly or by means of a program which I can assign on a button
click.