Av8tordude
Well-known Member
- Joined
- Oct 13, 2007
- Messages
- 1,074
- Office Version
- 2019
- Platform
- Windows
VBA Code:
Dim My Range as Range
Set MyRange = Range("Q7", Range("Q7").End(xlDown)).SpecialCells(xlCellTypeVisible)
WorksheetFunction.SumIf(MyRange, ">0")
I have this code sums value greater than zero. I'm using an autofilter and I would like to know how I can get the results if the rows are filtered?
Thanks