Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count number of rows, where non relevant rows are hidden
I want to count the number of rows i a worksheet. I have hidden the non
relevant rows in the sheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count number of rows, where non relevant rows are hidden
Enter and run this small sub:
Sub IAmTheCount() Dim r As Range, c1 As Long, c2 As Long For Each r In ActiveSheet.UsedRange.Rows If r.Hidden Then c1 = c1 + 1 Else c2 = c2 + 1 End If Next MsgBox (c1 & " rows are hidden") MsgBox (c2 & " rows are not hidden") End Sub It will report the number of hidden and un-hidden rows in your used range. -- Gary's Student "Pieter" wrote: I want to count the number of rows i a worksheet. I have hidden the non relevant rows in the sheet. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count number of rows, where non relevant rows are hidden
Use SUBTOTAL(2,rng)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Pieter" wrote in message ... I want to count the number of rows i a worksheet. I have hidden the non relevant rows in the sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count each cell that have a number and take that number and count. | Excel Discussion (Misc queries) | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Clean does not remove hidden formatting on a number | Excel Worksheet Functions | |||
Insert rows | Excel Worksheet Functions | |||
Count number of row where are data | Excel Discussion (Misc queries) |