When you are trying to find the cell that you are changing, make sure that you are referencing Target as being your changing cell as opposed to ActiveCell. If you use ActiveCell, it is going to be the ActiveCell after you return the command or tab to the next cell.
ActiveCell.Row when using the Return key will be (1) row below you Target Cell
ActiveCell.Column when using the Tab key will be (1) column to the right of your Target Cell
Use Target.Row or Target.Column
It is already dimensioned as a Range, and it will give you the correct information of the cell that changed in your WatchRange.
Originally Posted by tonyrosen
Figured it out ... I was "finding" the wrong cells. My "active" cell was REALLY the desired "active" cell plus one ... Here is the piece I fixed:
MyRow = ActiveCell.Row
'This is the Stop Date Column Number
MyColumn = ActiveCell.Column - 1
'This is the Start Date Column Number
MyColumnPrev = MyColumn - 2