Chemist, I was reading a post you assisted on and you showed the following VBA code for a date to populate automatically when a data field is changed. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("Y:AD")) Is Nothing Then Cells(Target.Row, 31) = Date End If End Sub My question is, how would I do this for more than one range and dates? For example, i need column AE to show that date if Y thru AD is changed, then I need column AH to show a date if fields AF thru AG are changed, etc...