Hello,

I have a price model with 9 worksheets. 5 of the 9 worksheets are data input worksheets. The 5 worksheets are for the Base Year, Option Yr 1, Option Yr 2 etc. I am trying to hide rows for the smaller version to capture fewer personnel and unhide rows for a larger version. In other words I am trying to make this workbook scalable. I have tried a macro to either hide or unhide 20 of the same rows on each of the worksheets at the same time but it doesn't work.

Any idea would be greatly appreciated.

Mark