View Single Post
  #1   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

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