We are supposed to be getting 2007 later this summer, but I'm not holding my
breath! VBA code would be great if it isn't too much trouble. Thanks for
the help!

Ken K.
--
akkrug


"akkrug" wrote:

Please let me know if there is any way to use formulas to modify cells that
are populated with drop down boxes from the Data Validation menu. One of our
users now wants to change all cells in a range to N/A if the First cell in
the range contains the value "No".

Thanks for all the help!!

Ken
--
akkrug