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.


--
oscar_acm
------------------------------------------------------------------------
oscar_acm's Profile: http://www.excelforum.com/member.php...o&userid=37362
View this thread: http://www.excelforum.com/showthread...hreadid=570569