Quote Originally Posted by ketats1 View Post
Hello,
...
I have a question: can you tell me on which column the macro refer for "region"??
If i need to modify the value of region, where can i do it??....
In the macro it only refers Col D and Col K which refers as w(i, 4) and w(i, 11) respectively.

Also write the following line before kTest in the worksheet module code.

Code:
If Target.Address(0, 0) <> "C1" Then Exit Sub
this restrcits the macro to fire when C1 changes.