Counting visible cells

  • Thread starter Thread starter Otto Moehrbach
  • Start date Start date
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
 
It just occurred to me to use a UDF in that cell. That will simplify
things. Otto
 
Back
Top