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 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.
Last edited by Preacher63; 06-04-2015 at 08:23 AM.
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.
![]()
Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Address = "$K$1" Then With Range("F3:F10") .EntireRow.Hidden = False End With For Each rngCell In Range("F3:F10") If rngCell = "Hide" Then rngCell.EntireRow.Hidden = True End If Next End If Application.EnableEvents = True End Sub
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks