I dont know much about VBA but can anyone help? I need a macro that will hide all rows where the formula result is zero as a result of the cost centre selected from a validation list?