Conversation Between ChemistB and Smalls427

1 Visitor Messages

  1. 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...
Showing Visitor Messages 1 to 1 of 1

Search Engine Friendly URLs by vBSEO 3.2.0