hi,

i have a workbook with four scenarios and one input sheet.

in input sheet - there is cell to get the value of retirement age.

is it possible; that when i enter a certain age lets say 55, then in all the other four scenario sheets should hide rows 15:20.

macro should pick the value from retiremnt age cell lets say b4, everytime it runs.

so in simple words, when i enter retirement age in cell b4 of input sheet, the following worksheets should hide the rows 15:20.

thanks in advance