I understand the code, and either would suffice. The problem I have is
having it execute upon a change in the drop-down.

Currently values re-calculate on the sheet in a series of INDEX
formulas. If you activate another cell on the sheet it works fine. If
you only change the drop down box, and don't select another cell, the
code does not execute.

What do you recommend?


*** Sent via Developersdex http://www.developersdex.com ***