| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
| 2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
| 2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
| 2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
| Range object to Array object conversion | Excel Programming | |||
Linear Mode
