MyTable.Cells.SpecialCells(xlVisible).Copy

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
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


.