excel help

[jcheko]

I have a table (range a5:s33) that is changing constantly and its being
updated. I need cell I1 and I2 to give me the date (I1) and time (I2) when
any of the cells within the range are modified....any help?...thanks

 

[מיכ×ל (מיקי) ×בידן]

Try the following Sheets Event-Macro:
-----------------------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, [A5:S33]) Is Nothing Then
[I1] = Date
[I2] = Time
End If
End Sub

 

[jcheko]

worked like a charm....thanks

Try the following Sheets Event-Macro:
-----------------------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, [A5:S33]) Is Nothing Then
[I1] = Date
[I2] = Time
End If
End Sub
---------------
Micky

I have a table (range a5:s33) that is changing constantly and its being
updated. I need cell I1 and I2 to give me the date (I1) and time (I2) when
any of the cells within the range are modified....any help?...thanks

 

[Gord Dibben]

Sure glad I responded to one of your multi-posts.

I had nothing better to do with my time.

Please post once in future.


Gord Dibben MS Excel MVP

worked like a charm....thanks

Try the following Sheets Event-Macro:
-----------------------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, [A5:S33]) Is Nothing Then
[I1] = Date
[I2] = Time
End If
End Sub
---------------
Micky

I have a table (range a5:s33) that is changing constantly and its being
updated. I need cell I1 and I2 to give me the date (I1) and time (I2) when
any of the cells within the range are modified....any help?...thanks