 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Worksheet Changes
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.  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Hi All, > [quoted text clipped - 9 lines] > > Steve > A bit more explanation along with layout and what desired output looks like. > [quoted text clipped - 18 lines] > > - Show quoted text - 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 SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com On Feb 26, 1:26 pm, "Don Guillett" <dguille...@austin.rr.com> wrote: > A bit more explanation along with layout and what desired output looks > like. [quoted text clipped - 22 lines] > > - Show quoted text - 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 >> A bit more explanation along with layout and what desired output looks like. >> [quoted text clipped - 31 lines] > >Steve |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.