Need to tweak code...Hide Rows Based on Cell Value

**kmlloyd** · 07-17-2015, 10:03 PM

I have the code below hiding columns based on the value in the respective cells.

Now I need to adjust this so it will also hide rows A9:A16 based on their cell values. They will either be blank or will say "HIDE" if that row needs to be hidden.

Private Sub Worksheet_Calculate()
Dim rCell As Range
For Each rCell In Range("D1:L1")
rCell.EntireColumn.Hidden = (rCell.Value = "HIDE")
Next rCell
End Sub

**alansidman** · 07-17-2015, 10:37 PM

Try this:

Private Sub Worksheet_Calculate()
Dim rCell As Range
For Each rCell In Range("D1:L1")
rCell.EntireColumn.Hidden = (rCell.Value = "HIDE")
Next rCell

For Each rCell In Range("A9:A16")
rCell.EntireRow.Hidden = (rCell.Value = "HIDE")
Next rCell
End Sub

**kmlloyd** · 07-21-2015, 01:05 AM

Thank you. When I use this, it seems to get caught up on something...it's "skipping" like it's trying to do something and then it gets stuck there until I hit Esc and end the execution.

When I hit Debug, the first instance of "Next rCell" is highlighted.

**kmlloyd** · 07-21-2015, 11:05 AM

Got it solved:

Private Sub Worksheet_Calculate()
Dim rCell As Range
Application.EnableEvents = False
For Each rCell In Range("D1:L1")
rCell.EntireColumn.Hidden = (rCell.Value = "HIDE")
Next rCell


For Each rCell In Range("A9:A16")
rCell.EntireRow.Hidden = (rCell.Value = "HIDE")
Next rCell
Application.EnableEvents = True
End Sub

Need to tweak code...Hide Rows Based on Cell Value

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Need to tweak code...Hide Rows Based on Cell Value

Re: Need to tweak code...Hide Rows Based on Cell Value

Re: Need to tweak code...Hide Rows Based on Cell Value

Re: Need to tweak code...Hide Rows Based on Cell Value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Hide rows based on cell value - VBA code

Looking for a VBA code to hide rows based on a single cell value

Help: Code to hide multiple rows based on different cell values

VBA code to hide/show rows based on value in each row

Code to show/hide rows based on Y

Modify code to hide rows based on the contents in a cell.

Bookmarks

Bookmarks

Posting Permissions