VBA to hide and unhide rows based on a cell value in the row

I am try to crate an active worksheet that changes as options change.
If the the cell in column 6 RANGE (F3:F10) = "Hide" hide the entire row otherwise unhide the row.

I'd use a worksheet_change event to auto trigger when that cell changes. Don't forget you need code upfront to unhide everything each time.

Please Login or Register  to view this content.