Sum Filtered values

  • Thread starter Thread starter Pedro
  • Start date Start date
P

Pedro

Hi

I have a table and applied a Filter to that table
I selected a value of a specific field of that table and now it shows me
rows 10,11,12,50,51,53
What code should I write in order for it to sum only the cells that are
shown and not the rows between?

Regards,
Pedro
 
MyTable.Cells.SpecialCells(xlVisible).Copy

Patrick Molloy
Microsoft Excel MVP
 
Back
Top