Saturday, April 10, 2010

Running Code On Cell Change in Excel

  


Here's a nice code that I found that runs a code whenever there's a
change in an Excel cell. 

I found it on the following: 


http://www.ozgrid.com/forum/showthread.php?t=68055 


  Private Sub Worksheet_Change(ByVal Target As Range)
      Dim iSect As Range
      Set iSect = Application.Intersect(Target, Range("Change"))
      If Not iSect Is Nothing Then
          Call Code
      End If
  End Sub 



Where "Code" is the macro that runs anytime there's a change in the
"Change" range. 

No comments:

Post a Comment