Actually, I need all the product mode be included on the lists and hides only when we have no sales for the year. your VBA Code works great and this is just what I needed with your letter A parameter. unfortunately, I am not familiar yet and I don't know how VBA works so I think I have to study it.