Worksheet_Change event doesn't get fired

[captedgar]

Hi there

The Worksheet_Change event doesn;t get fired again to capture the exact row infomation.

The following is the macro i have

Please Login or Register  to view this content.

This works the first time when i change a cell value from No(which is default) to Yes on a certain cell in the current row. But when i change the same Yes to No and then Yes again and step through the code in debug mode, after previousTargetAddress = Target.Address line it justs straight to Else statement and then end if

Please advice

[shg]

Where are all the variables declared?

Variables whose values are intended to persist must be declared as static.

[JBeaucaire]

You have created this code specifically to test if Target.Address = PreviousTargetAddress.

Based on your code:

1) if the address is NOT the same as the last cell that was triggered, do the code
2) if the address IS THE SAME, do nothing, go straight to END IF.

As I mentioned in your prior post, if you no longer wish to do this current/previous address test and ALWAYS trigger the activity shown in your code, take out the test at the top of the IF/THEN.

Do you see what I'm talking about?

Please Login or Register  to view this content.