using AutoFilter object
 

I want to perform calculations on an auto-filtered range,
but can't seem to be able to grab only the "unhidden" cell
values. I've goofed around with ...

activesheet.autofilter.range.specialcells
(xlCellTypeVisible).select

.... but stuck as to how to grab individual cells from that
collection.