Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jaymz Brown   on Oct 11 In MS Office Category.

  
Question Answered By: Harriet Hughes   on Oct 11

I decided to give this a whirl and part way through troubleshooting
my disfunctional code and probable mis-use of a range variable, I
remember reading something probably on MSDN about the variable
called "Target" which gets automatically populated in the _Change Sub
parameter list.
This would be from ther DUH! department, then.
The change  event properly captures the changed cell(Range) in the
variable "Target" then the _Change event  fires even if the ActiveCell
(object?) (which you now have access to in the sub) is the one you
moved *to*. Makes some sense as when you are actually *in* the change
sub, you are in the new cell.

Share: 

 

This Question has 13 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Capturing a change BEFORE leaving a cell Or get search suggestion and latest updates.


Tagged: