Remove all filters and or tables from several files at once

[Truiz]

Good evening chaps,

I have an issue at hand, I'm trying to merge several files at once they are all located in the same folder which makes the task at hand easier, however some of the files have filters and or tables thus such files will only copy the filtered information when I actually need the whole dump, how could I achieve the task of removing the filters and tables from all the files in the folder?

Regards,

 

[Delgy]

You could try unhiding all columns and rows when opening each file or create a cycle to do this with all the files in the folder

[COLOR=#333333][FONT=Menlo]Columns.EntireColumn.Hidden = False
[/FONT][/COLOR][COLOR=#333333][FONT=Menlo]Rows.EntireRow.Hidden = False[/FONT][/COLOR]