I'm not sure I understand what you're asking. It SOUNDS like you want a list of unique values from column "A"
there's lots of ways to do this. Let me know if that's what you're looking for, and what version of Excel you are using. Paul ________________________________ From: Meimei <xxu8810...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Thu, September 9, 2010 9:25:26 PM Subject: $$Excel-Macros$$ How to copy the list of autofilter selection? Hi all, I have a question about copy the list of unique values generated by autofiltering in VBA. For example, if in column A I have cells listing some animal names, dog, cat, dog, sheep, cat, dog, cat, cat, dog, sheep. If I do an autofiltering on column A, the autofilter will have the selection of all, (Total), cat, dog, sheet. My question is whether there is a way to copy this autofilter's selections to other cells? Thanks a lot! -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
