Hi
have a look at
http://www.contextures.com/xlautofilter03.html#Copy

--
Regards
Frank Kabel
Frankfurt, Germany

Hi all,

Does anyone know how to only copy a range whit an autofilter has
filted:

i.e. the macro has filtered field 10 for blanks, all that is required
to be copied is the filtered rows to a sheet named "extract"

Thanks in advance
Paul


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