Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter-Filtered List Scan
Hi All
I use an autofilter on my 'database sheet' of records to selectively filter the required data. I currently scan the visible filtered list and transfer data to my report and chart sheets. I scan from the first row to the last filtered and visible row. Testing each row using Not EntireRow.Hidden. This works fine. What concerns me is that as my 'database sheet' get longer, that scanning ALL rows, and selecting the not hidden rows is a big overhead and things will slow down. IS there a better way? For example copying the filtered list to an array and scanning this - I am not sure how to do this. -- Regards, Nigel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count rows in a filtered list when using AutoFilter? | Excel Worksheet Functions | |||
Scan column for first of a list | Excel Discussion (Misc queries) | |||
Autofilter and count on filtered data | Excel Worksheet Functions | |||
macro to scan list | Excel Programming | |||
Selecting Filtered records only when AutoFilter is on | Excel Programming |