I running macro, the macro create sheet "Data" with AutoFilter, filter information, cut and paste this information in new sheet.

Return with following command a original sheet.

Worksheets("Data").Select

And need what display AllData for generated other filter

I used this command ActiveSheet.ShowAllData, because not display information

I need help.

tks.