How to undo changes made to Excel sheet programatically
 

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

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

Please help!!!!!!!!

Thanks,
Samee

--
Message posted from http://www.ExcelForum.com

How to undo changes made to Excel sheet programatically
 

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.