Hiding rows or columns attached to the value of a cell

  • Thread starter Thread starter loeclint
  • Start date Start date
L

loeclint

Basically I want to automatically hide a row when the value of one of
it's cells is zero. Thanks a lot.
 
have you though of the implications of this? this means in other words
that if the value is fixed and not from a formula than even if you use
the menus to unhide the row, it will automatically hide again once it
is un hidden ... ?

if this is really what you wish to do and have thought the thing out
right i might have a solution.

Alexandre
 
If you really want that, put this in the worksheet code module
(right-click the worksheet tab and choose View Code):

Private Sub Worksheet_Calculate()
Dim rRow As Range
Application.EnableEvents = False
For Each rRow In Me.UsedRange.Rows
With rRow
.Hidden = Application.CountIf(.Cells, 0)
End With
Next rRow
Application.EnableEvents = True
End Sub

Every time the sheet calculates, each row will be evaluated for a cell
containing zero. If one is found, the row will be hidden.
 
JE McGimpsey,
he will have to add a little something to specify a column to evaluate
;)
 
The OP didn't indicate that s/he wanted to specify a column. S/he said
"I want to automatically hide a row when the value of one of it's (sic)
cells is zero."


"Alexandre (www.pointnetsolutions.com)"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop through a range of rows and hide based on conditions 3
Expand and collapse rows 7
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
hiding rows 6
Excel Help to copy information from one row at a time to another sheet 1
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Code to hide rows if cell in another WS is ="No" 11
Hide rows in table based on 1 empty cel of the same row. 1

Back
Top