I have a macro that does the following, it deletes all the data within the
spreadsheet, imports 2 files and then saves the spreasheet. This macro works
fine but when filters have been used within the spreadsheet and i come to run
the macro the spreadsheet freezes on me everytime. Even if i clear all the
filters the error still appears. To work around it i have to remove the
filters, exit and save the spreasheet and then re-open it. The Macro then
works ok again.

Thanks