Worksheet event macros are designed for a specific worksheet and only apply to the worksheet they are installed into.
Examples change event, double-click, cell change, right-click.
[offset], [insrtrow] [dclick], [copyformulas], [Insert Blank Rows], [moreresize], [Change Event], [extended], [Alt Blanks], [Col Achg], [before_a], [reconcile], [Manual Insert], [Delete K], [Delete R], [addendum], [sign_onright], [fixrightminus], [clear Cols], [extra Totals], [blankrows], [multilabel], [#VALUE!
In the example below (this is not the end result what I want, just proof of concept that I can easily change cell B1), I am attempting to change cell B1 to values 1, then 2, then 3 and seeing what the results are and will later adapt this to be more flexible than just 1, 2, 3 Private Sub Command Button2_Click() Dim counter As Integer For counter = 1 To 3 Application.
Enable Events = False Worksheets("Hurdle Evaluation").
By referencing cells in the current row any insertion or deletion of lines will cause formulas to be updated.
In order to refer to cells elsewhere but to name only cell addresses in the current row, OFFSET will be used as follows: Replication is made easier by grabbing and dragging the fill handles and with the use of shortcuts Ctrl D (Fill Down), and Ctrl R (Fill Right).
Unfortunately you would not see both dates -- the date on your check and the date it cleared.