Count Visible Cells Within A Selection

Hi all,

I'm needing help putting a macro together that will count only visible cells within a selection. The first code wil simply count all cells with a numerical value within a selection. However, if I filter a selected column, I'd like to be able to only count
the visible cells. The 2nd is code, shown is from a Sum Visible Cells Function Code
which works great in combination with a formula within a cell that contains the
FunctionName for a set Range IE (=Sum_Visible_Cells(N3:N672)

If someone can modify the Funtion (if needed) and the Count_Selection code so it
could possibly work in conjunction with the FunctionCode, I would greatly appreciate it.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I'm sure others will find it very useful for there needs too.


Thanks,

BDB

This will count visible cells regardless of content. It simply looks to see if the row is hidden or visible.

Please Login or Register  to view this content.

How about just ...

Please Login or Register  to view this content.

Thanks Palmetto, this works great.

SHG, I could not get the function to code to work. I'm assuming I must not be doing something right in setting it up for use.

Using the function with the formula in any used cell for the result returned a value of 1.

I've run out of time today. I'll have to play with this some more tomorrow.

I'm wondering how something like this would work for counting a variable column range
across a variable row range. Of course it's not setup to count visble cells.

I've not

Please Login or Register  to view this content.

Any thoughts opinions additions, welcome.

Thanks guys.

Originally Posted by bdb1974

SHG, I could not get the function to code to work. I'm assuming I must not be doing something right in setting it up for use.

AFAIK you can't use SpecialCells in Functions called from cells.