Counting visible cells

O

Otto Moehrbach

Excel 2002, Win XP
I setup an AutoFilter procedure with VBA for a user. In it I used a
Worksheet_Calculate macro to trigger a count of the visible cells as the
user selects items to filter. This count is displayed in a cell.
My question: Can I do this count of the visible cells with a worksheet
function?
Thanks for your help. Otto
 
O

Otto Moehrbach

It just occurred to me to use a UDF in that cell. That will simplify
things. Otto
 

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

Select Text to End of Footnote 9
Word macro that can call cells out of Excel for a find and replace 0
count visible cells after autofilter 1
How to get the count of filtered rows after applying autofilter? 2
How activate "NUM" thingie? 10
Using VBA to Copy Ranges to a PreSet Dim formula AND Cell Propertys. 0
Count After Filter in macro 2
Fixing text wrap in merged cells 1

Top