Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide rows, but not blank rows used for formatting
Can you tell me how to solve the issue of not hiding the totally blank
rows that are part of the worksheet for formatting purposes, but do hide the rows that have zeros in them based on formulas. I added the hiderows/showrows to VBE, but it removes all the zero and blank rows. Sub Hiderows() Dim lr As Long, i As Long With ActiveSheet lr = Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To lr If Cells(i, 3) = 0 And Cells(i, 4) = 0 Then Cells(i, 1).EntireRow.Hidden = True End If Next End With End Sub I would be most appreciative for a fast solution. Thanks! Heidi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Blank Rows | Excel Worksheet Functions | |||
Hide Zero Rows - But Not Blank Rows | Excel Programming | |||
Macro to hide blank rows | Excel Programming | |||
hide blank rows | Excel Programming | |||
Hide Blank Rows | Excel Worksheet Functions |