excel help

  • Thread starter Thread starter jcheko
  • Start date Start date
J

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
 
worked like a charm....thanks

מיכ×ל (מיקי) ×בידן said:
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


jcheko said:
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
Click to expand...
Click to expand...
 
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

????? (????) ????? said:
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


jcheko said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top