Hi PvtJoker,

See if this does what you want. If you put the dropdown in a cell instead of an object it is much easier. See the attached for how I'd do this problem.

On Change Hide Rows.xlsm