View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pauluk[_13_] pauluk[_13_] is offline
external usenet poster
 
Posts: 1
Default Copy an autofilter range

Hi all,

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

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

Thanks in advance
Pau

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