Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide rows which add up to zero
Hi,
I use the following code to hide the rows which add up to zero. But the sheets is getting long, over 6000 rows, and it takes long to run the macro. Is there a quicker way? Cheers, Harold ------------------------------------- Sub hide() a = Range("z2").Value For b = 3 To a If Range("z" & b).Value = 0 Then Rows(b).EntireRow.Hidden = True Else Rows(b).EntireRow.Hidden = False End If Next b End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide rows which add up to zero
I don't see what you're adding here.
My suggestion would be to look at apply an autofilter to that column and filter to hide rows with 0's in that column/field. mohavv wrote: Hi, I use the following code to hide the rows which add up to zero. But the sheets is getting long, over 6000 rows, and it takes long to run the macro. Is there a quicker way? Cheers, Harold ------------------------------------- Sub hide() a = Range("z2").Value For b = 3 To a If Range("z" & b).Value = 0 Then Rows(b).EntireRow.Hidden = True Else Rows(b).EntireRow.Hidden = False End If Next b End Sub -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows won't hide | Excel Discussion (Misc queries) | |||
cut rows without cutting hide rows | Excel Discussion (Misc queries) | |||
Hide the rows | Excel Worksheet Functions | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
hide rows | Excel Discussion (Misc queries) |