ExcelBanter - Sum Filtered values

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Sum Filtered values (https://www.excelbanter.com/excel-programming/287210-sum-filtered-values.html)

PEdro

Sum Filtered values

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

patrick molloy

Sum Filtered values

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

.

All times are GMT +1. The time now is 08:07 PM.