[Solved] Insert date last modified

  • Argh!! I know I used to know this...

    What is the funciton / code to insert into one cell the date and time another cell was last modified.

    It needs to work even if the change wasn't applied directly to the cell (i.e. the cell's value changed as a result of a lookup)



  • Haven't tested this btw but give it a go:


    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

  • Hi Iridium,

    Thanks. This is cool, but only works if I apply the change directly to the cell. If the value of the cell has changed as a result of me changing another cell which is referenced by that cell's formula, it ignores it.

    Does that make sense or am I rambling?!

  • I solved this myself, but with a different workaround. Although I have to admit I don;t understand why it works.

    The cells I was talking about were changing as a result of a lookup that was referencing values that changed when a refresh was run (from a web query). In case anyone's interested, this is what I used...

    At the end of the refresh sub, I call this one:

    'Inserts the date the cells were last updated (the date the refresh ran)

    Sub dateconsol()

    ActiveCell.FormulaR1C1 = "=NOW()"
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=False
    Application.CutCopyMode = False
    End Sub

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!