VBA Advanced Filter causing Excel file to corrupt...

You should put your code in those code tags
the # in the tool bar above the window you type into.

And for what it is worth an example spreadsheet would be even better.

Just a wild stab in the dark - but its quick to test - do you have a lot of conditional formatting? if so try clearing it and seeing if it still fails.

Hi Scottiex

Thanks for feed back. Tried what you have suggested.
Pablos