I have 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...
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
“To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks