forgot to mention, the autofilter are manually done (not via a macro)

for each sh in ActiveWorkbook.Worksheets
sh.AutofilterMode = False
Next
Worksheets.Select
Cells.Copy
Cells.PasteSpecial xlPasteValues
Worksheets(1).Buttons.Delete
Cells(1).Select
Worksheets(1).Select
Application.CutCopyMode = False

--
Regards,
Tom Ogilvy



"matthias" wrote:

forgot to mention, the autofilter are manually done (not via a macro)

thanks for the reply, but I was not clear enough, my mistake
now the macro copies without problem, but the filters aren't applied in
the new workbook (non blank cells filter)

is this possible to be arranged

regards,
mat

hi tom
is it not possible to run the autofilter for all new sheets once the
data is copied to the new sheets

something like for each sh in ... apply autofilter on a1:a11 with
criteria:="<"??

thanks