Hi
see
http://www.contextures.com/xlautofilter03.html
for applying an autofilter and copying the filtered rows.

--
Regards
Frank Kabel
Frankfurt, Germany


Hi i have a sheet it has the heading "Name" in column a. i want to
make a macro that applies a autofilter to the whole of columm a. then
return the values in the autofilter in column c.

Can anyone please help. I've been trying to do this for ages but
cannot manage it.

Thanks Chris.


---
Message posted from http://www.ExcelForum.com/