automatic adjustment
 

i am working on a worksheet where at cell b15 there is a drop down menu
if has YES and NO as options in case of YES row no 13 is unhidden and
in case of NO row no 13 is hidden. however i alos want that in case of
NO whatever figures are put at B13 to be deleted. how to do the same

automatic adjustment
 

Post your code for comments.

--
Don Guillett
SalesAid Software

"daidipya" wrote in message
oups.com...
i am working on a worksheet where at cell b15 there is a drop down menu
if has YES and NO as options in case of YES row no 13 is unhidden and
in case of NO row no 13 is hidden. however i alos want that in case of
NO whatever figures are put at B13 to be deleted. how to do the same