MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Auto Filtered lists


Posted by DG on May 02, 2000 1:15 PM

Can anyone tell me how, using VBA, to return only those
values meeting the criteria of a filtered list? Example:
If rows 1506,1508 & 1513 are visible under the autofilter,
how can I evaluate only those values for the information
needed in another worksheet without having to loop through
all of the hidden rows which contain unneeded data?


Posted by Celia on May 03, 2000 2:40 AM

DG
The macro recorder can be used to find out the code to select the visible cells only (i.e. by recording Edit>GoTo>Special>VisibleCellsOnly).

It should produce the code :-
Selection.SpecialCells(xlCellTypeVisible).Select

Celia

Posted by DG on May 10, 2000 7:56 AM

Thanks Celia,

You saved me hours of work.
DG

Posted by DG on May 10, 2000 7:58 AM

Thanks, Celia

You saved me hours of work.