Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Hidden Rows
Is there a way in Excel where I can count rows and columns and get a number
that excludes any hidden rows or columns? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Hidden Rows
In a subroutine/macro?
For a single area range, you can get the number of visible rows/columns with something like: Option Explicit Sub testme() Dim myRng As Range Dim myVisibleCell As Range Set myRng = ActiveSheet.Range("a1:x99") Set myVisibleCell = Nothing On Error Resume Next Set myVisibleCell = myRng.Cells.SpecialCells(xlCellTypeVisible).Cells( 1) On Error Resume Next If myVisibleCell Is Nothing Then MsgBox "0 visible rows and 0 visible columns!" Else MsgBox "Visible Rows: " _ & Intersect(myVisibleCell.EntireColumn, myRng) _ .Cells.SpecialCells(xlCellTypeVisible).Cells.Count _ & vbLf & _ "Visible Cols: " _ & Intersect(myVisibleCell.EntireRow, myRng) _ .Cells.SpecialCells(xlCellTypeVisible).Cells.Count End If End Sub Covington wrote: Is there a way in Excel where I can count rows and columns and get a number that excludes any hidden rows or columns? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting non-blank cells in a column, excluding hidden rows | Excel Worksheet Functions | |||
Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
Counting None Hidden Lines | Excel Discussion (Misc queries) | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) |