View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geo geo is offline
external usenet poster
 
Posts: 4
Default 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.