Hi All,
Does anyone know of a macro that I can run that will delete all sheets in the workbook with the exception of a named sheet (that will always be constant)?
The problem I have that is I run a macro before this and therefore the number of sheets to delete always varies and when I recorded a macro to do this, it didn't like it!
Thanks,
Paul
Does anyone know of a macro that I can run that will delete all sheets in the workbook with the exception of a named sheet (that will always be constant)?
The problem I have that is I run a macro before this and therefore the number of sheets to delete always varies and when I recorded a macro to do this, it didn't like it!
Thanks,
Paul