Timestamp Cell based on Change in a Range

[Zeptune]

Hello,

I have been looking on this forum all morning testing all types of code but for whatever reason, I can't get exactly what I want (even though it should be easy).

I would like to place a timestamp in cell "B22" each time a anything changes within cell range "C5:L20".

Any help would be truly appreciated!

Thanks... Zep

 

[VoG]

Hi. Do you change values in the range C5:L20 or do those cells contain formulas?

 

[Zeptune]

The cells originally have formulas, but when changes are made they are manually done; thus eliminating the formula and changing the value.

 

[VoG]

That makes it easier.

Right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("C5:L20")) Is Nothing Then Exit Sub
Range("B22").Value = Now
End Sub

then press ALT + Q to close the code window.

 

[Zeptune]

Thank You! Worked perfectly once I closed excel reopened and enable the macros (duh!)

 

[Tonyhu342]

Reopening this to make it more complicated. What if cells c5:l20 contained formulas?