Count non-hidden rows
 

Is there a way to count non-hidden rows in a column?
--
Art

Count non-hidden rows
 

Look in the help index for SUBTOTAL and read the part about hidden non

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Art" wrote in message
...
Is there a way to count non-hidden rows in a column?
--
Art

Count non-hidden rows
 

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

--
Rick (MVP - Excel)


"Art" wrote in message
...
Is there a way to count non-hidden rows in a column?
--
Art

Count non-hidden rows
 

Lots of ideas for counting he
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)

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Don Guillett" wrote:

Look in the help index for SUBTOTAL and read the part about hidden non

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Art" wrote in message
...
Is there a way to count non-hidden rows in a column?
--
Art

.

Count non-hidden rows
 

Ryan; function_num 2 is to include hidden values. To ignore hidden values the
function_num is 102

=SUBTOTAL(102,A1:A100)

--
Jacob


"ryguy7272" wrote:

Lots of ideas for counting he
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)

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Don Guillett" wrote:

Look in the help index for SUBTOTAL and read the part about hidden non

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Art" wrote in message
...
Is there a way to count non-hidden rows in a column?
--
Art

.

Count non-hidden rows
 

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?"

--
Jacob


"Jacob Skaria" wrote:

Ryan; function_num 2 is to include hidden values. To ignore hidden values the
function_num is 102

=SUBTOTAL(102,A1:A100)

--
Jacob


"ryguy7272" wrote:

Lots of ideas for counting he
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)

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Don Guillett" wrote:

Look in the help index for SUBTOTAL and read the part about hidden non

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Art" wrote in message
...
Is there a way to count non-hidden rows in a column?
--
Art

.