Sum Filtered values

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
 
P

Patrick Molloy

MyTable.Cells.SpecialCells(xlVisible).Copy

Patrick Molloy
Microsoft Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add sum formula automatically using VBA 3
lastrow function help 6
Auto Filter 3
Selecting AutoFilter Rows 4
Summing Criteria with Index - Match 3
Substituting CRLF with "+" - Transforming a cell containing numbersin a sum of its numbers 2
Autofilter Get selected cells value 1
Get visible pivot table items 4

Top