VBA Time Stamp When Cell Changes.

[alexfooty]

Quite simply, if the value in cell I13 in a worksheet changes I would like a date & time stamp to appear in cell M8 which updates every time cell I13 changes.
Many thanks and Merry Christmas to you all.

 

[alexfooty]

Tried inserting code at end of the macro - no joy.
My existing macro is just one that I simply recorded of the steps I went through.

Sheets("Medication").Select
    Range("B1").Select
    Application.CutCopyMode = False
    ActiveCell.FormulaR1C1 = "=R[2]C[-1]+RC[-1]"
    Range("B1").Select
    Selection.Copy
    Range("A3").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Columns("A:A").Select
    Selection.EntireColumn.Hidden = True
    Columns("E:E").Select
    Selection.EntireColumn.Hidden = True
    Range("B1").Select
    Application.CutCopyMode = False
    Selection.ClearContents
        Range("B1").Select

 

[Fluff]

Thanks for that, but it's only part of the code & doesn't show where you are changing I13

 

[alexfooty]

I need to start this reply with a sincere apology. It's a long time since I set this worksheet up.
On close examination of the cells involved, cell I13 actuall contains a formula "=D3-E52" which results in cell I13 increasing by "1"
Not sure if this is any help at all.
Sorry for messing you around (it's my age!!!)

 

[eduzs]

Sheets("change_to_target_worksheetname").Range("M8") = Format(Now, "d/m/yyyy HH:MM:SS")

 

[alexfooty]

Sorry eduzs, where do I place this?

 

[eduzs]

At end of the macro.

 

[alexfooty]

The cell I13 contains the formula "=D3-E52". If the cell increases by one nothing happens to the timestamp in M8. However, if I delete the formula from I13 the datestamp changes!!

 

[alexfooty]

Everyone appears to have given up. Can't say I'm surprised.

To recap - Cell I13 contains a simple formula '=D3-E52'. Each time the value in cell I13 changes, I would like a date & time stamp to appear in cell M8 which updates every time cell I13 changes.
Anyone still interested?

 

[alexfooty]

Obviously there's no-one interested in solving this problem Ah well....
This is the first time that Mr Excel has failed to come up with a solution to any of my questions.