vba or excel help

[jcheko]

I need to figure out a formula that returns the date when the spreadsheet was
last modified. any changes number, letter, symbol...if I make any change I
need the formula to return back the date teh spreadsheet was last
modified...any
help....thanks

 

[jcheko]

your macro does work and it will put the date and time you included in the
quotation signs that is cool, but it won't recognize if I modified the
spreadsheet, all I am saying is that if between "range a5:s33" I changed
something on it, the date should update, do you have another suggestion?
thanks alot

 

[jcheko]

thanks for your help..for now I am going to use a button in my spreadheet
linked to your macro..it is working well....I will still have to figure it
out on the changes for the spreadsheet though...but for your time...very much
appreciated.

 

[Gord Dibben]

Where do you want the modified date/time to be entered?

You can return that info to a cell or cells using event code.

Do you want it immediate or when you save or??

Can be done easily and automatically without hitting a button.

Tell us where you want the info displayed and when.


Gord Dibben MS Excel MVP