A
Art
Is there a way to count non-hidden rows in a column?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
Look in the help index for SUBTOTAL and read the part about hidden non
R
Rick Rothstein
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
Dim RangeToCount As String, VisibleRows As Long
.....
.....
RangeToCount = "A1:A100"
On Error Resume Next
VisibleRows = Range(RangeToCount).SpecialCells(xlCellTypeVisible).Count
R
ryguy7272
Lots of ideas for counting here:
http://www.contextures.com/xlFunctions04.html
Good info here too:
http://www.ozgrid.com/Excel/excel-subtotal-function.htm
You need something like this:
=SUBTOTAL(2,A1:A10)
http://www.contextures.com/xlFunctions04.html
Good info here too:
http://www.ozgrid.com/Excel/excel-subtotal-function.htm
You need something like this:
=SUBTOTAL(2,A1:A10)
J
Jacob Skaria
Ryan; function_num 2 is to include hidden values. To ignore hidden values the
function_num is 102
=SUBTOTAL(102,A1:A100)
function_num is 102
=SUBTOTAL(102,A1:A100)
J
Jacob Skaria
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?"
numerics instead OP is looking for "count non-hidden rows in a column?"