increasing value of cell on save

Hello,

I have a worksheet that I need a piece of code for, Cell E1 is an amendment number that increases every time a new one is put out, so they can be tracked.

Every time the sheet is saved the value in cell E1 needs to increase by 1.

any ideas??

thanks reg

you could just put in workbook module

Please Login or Register  to view this content.

e1 will increment by 1 everytime workbook saved