vba or excel help

  • Thread starter Thread starter jcheko
  • Start date Start date
J

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
 
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
 
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.
 
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
 
Back
Top