View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_5_] Otto Moehrbach[_5_] is offline
external usenet poster
 
Posts: 27
Default Counting visible cells

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