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.
Bookmarks