Thank you, this helps; can anyone tell me what the additional code is so that the rows will unhide when the value is a 1? Needs to be able to "toggle" back and forth based on the value in G16, which contains a formula. Thanks again for any help.