Hi,
I have created timestamps for multiple tabs, but they all seem to override each other, which means only one tab timestamp works at any one time.
How do i get them to operate on different tabs without effecting each other?
Code i am using which works but not for multiple timestamps on multiple tabs seprately.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myTableRange As Range
Dim myDateTimeRange As Range
Dim myUpdatedRange As Range
Set myTableRange = Range("B6:F15")
If Intersect(Target, myTableRange) Is Nothing Then Exit Sub
Set myDateTimeRange = Range("G" & Target.Row)
Set myUpdatedRange = Range("G" & Target.Row)
If myDateTimeRange.Value = "" Then
myDateTimeRange.Value = Now
End If
myUpdatedRange.Value = Now
End Sub
I have created timestamps for multiple tabs, but they all seem to override each other, which means only one tab timestamp works at any one time.
How do i get them to operate on different tabs without effecting each other?
Code i am using which works but not for multiple timestamps on multiple tabs seprately.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myTableRange As Range
Dim myDateTimeRange As Range
Dim myUpdatedRange As Range
Set myTableRange = Range("B6:F15")
If Intersect(Target, myTableRange) Is Nothing Then Exit Sub
Set myDateTimeRange = Range("G" & Target.Row)
Set myUpdatedRange = Range("G" & Target.Row)
If myDateTimeRange.Value = "" Then
myDateTimeRange.Value = Now
End If
myUpdatedRange.Value = Now
End Sub