Hi George,

SpecialCells has a limit of 8192 areas, could that be the problem. If so
work with chunks of up to 16000 rows at a time in the entire selection.

Regards,
Peter T


"G Lykos" wrote in message
...
Help! Have the following snippet, am running into a problem were the
autofilter screens out two records in the data set but the selection set
number of items and the selection set count are different!

Selection.Autofilter Field:=110, Criteria1:="<Test"
Range("A1").CurrentRegion.Sort , Header:=xlYes, _
Key1:=Range("DG1"), Key2:=Range("AZ1")
Range("DG1").Offset(1).Select
Range(Selection,
Selection.End(xlDown)).SpecialCells(xlCellTypeVisi ble).Select
Set ASN = Selection
iMax = ASN.Count

The final selection count, and iMax, reflect the correct number of visible
cells. However, range ASN contains all cells, both visible and invisible,
determined by stepping through debug.printing ASN(n). Why am I picking up
invisible cells in the selection set, and how can the selection set count
be
different than the number of selection set elements??

A subsequent work-around was to copy the entire worksheet after filtering
and sorting and paste it into a scratch worksheet, then set ASN there, but
I'd much prefer to avoid that gyration. Any ideas?

Windows XP, Excel 2003 SP3.

Thanks!
George