Hello,

I am trying to write some code which will allow me to delete the sheets at the end of a workbook automatically when I run a macro. The macro imports a number of worksheets with data in them and this then populates a spreadsheet. Before doing this, I want the macro to search the workbook and delete any sheets which have been imported before importing the new ones.

The problems I have include:-
the sheets vary in number from one run to the next.
the sheets do not have common names.

Can anyone help?