Last Updated

[dknowles2004]

Hi

I am putting together an Excel spreadsheet and need to put the data and time the spreadsheet was last saved into a cell (eg. A1).

It would be even better if I could also have another cell (A2) with a version number that increments by 1 each time the spreadsheet is saved. Any ideas on this please?

Can anyone help me on this at all?

Thanks.

David

 

[GlennUK]

Have a look at the Workbook_BeforeSave workbook event.

 

[dknowles2004]

Date Completed but Version incomplete

Thanks . I have used the following code:

Range("A1") = Now        

I still can't figure out the version code though!!

Help![/quote]

 

[GlennUK]

Range("A2").Value=Range("A2").Value+1