Count non-hidden rows

  • Thread starter Thread starter Art
  • Start date Start date
Look in the help index for SUBTOTAL and read the part about hidden non
 
If you meant using VBA code, something like this should work...

Dim RangeToCount As String, VisibleRows As Long
.....
.....
RangeToCount = "A1:A100"
On Error Resume Next
VisibleRows = Range(RangeToCount).SpecialCells(xlCellTypeVisible).Count
 
Ryan; function_num 2 is to include hidden values. To ignore hidden values the
function_num is 102

=SUBTOTAL(102,A1:A100)
 
And I dont think the OP is looking for count() which gives the count of
numerics instead OP is looking for "count non-hidden rows in a column?"
 
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

Subtotal across a row 1
=counta() unless row is hidden 5
Exclude Hidden Row Values 4
Counting only displayed cells in the column 3
Ignore Hidden Rows and Count of distinct values 3
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
CountIf previous cell formula 0
COUNT rows on external sheet if between date range 3

Back
Top