Worksheet Changes

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi All,

HYCH

Have a worksheet that has data in the range A5:I105, would like cell
a2 to show a date that any of this data has changed, was thinking of
using a worksheet change_Event to manage this but not sure of how to
go about setting this up, have used the simple change event for a
single selection i.e A1 or B4 but not with a range area.


Any help would be Great

Steve
 
A bit more explanation along with layout and what desired output looks like.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software







- Show quoted text -
Click to expand...

Hi Don,

Thanks for your reply, would like to use a change event along with the
Now() to update Cell a2 with the current time and date, when the cells
in A5:I105 (which contain data) are changed, but only if these cells
are adjusted in any way,
If no adjustments are made to the range("A5:I105") then the cell a2
would be unchanged.


Does this help ?


Steve
 
Right click sheet tab>view code>copy/paste this

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("a5:i105")) Is Nothing Then
Range("a2") = Now
End If
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
A bit more explanation along with layout and what desired output looks
like.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software







- Show quoted text -
Click to expand...

Hi Don,

Thanks for your reply, would like to use a change event along with the
Now() to update Cell a2 with the current time and date, when the cells
in A5:I105 (which contain data) are changed, but only if these cells
are adjusted in any way,
If no adjustments are made to the range("A5:I105") then the cell a2
would be unchanged.


Does this help ?


Steve
 
Steve

Would these be manual changes or the results of calculation?


Gord Dibben MS Excel MVP
 
Back
Top