Re: Hide Rows based on drop down box
Oh, so there is no way that you can actually have multiple event change statements?
I've uploaded a copy. Its a pity you cant actually see how the cells are populated but hopefully even with this copy's limited functionality should still be enough for you to see what is potting.
Basically I have a formula in A10 that will look up a customer's classification from a list. Some customers have not been classified, where there will be a #N/A. If the customer has been classified but is not a "key account holder", the formula will return a blank. If blank I basically need rows 9&10 to be hidden.
Im not worried about higher and lower case incompatibility with the code at the moment as all inputs will be drop down menu driven.
Further, I think I will just write in an ISNA formula so instead of showing #N/A, will display warning text.
So really its mostly about hiding rows 9&10 if the merged cell A10 returns a blank value.