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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment