Thank you Jeffrey and Sparks for the code. Both work great in the sample file but I failed to mention that the actual workbook contains sheets that should not be affected by the HideRows macro. The macro should be applied to specific sheets in the workbook.