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
"Otto Moehrbach" wrote in message
...
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