hi
ive used the record macro facility and came up with this code
i know this is probably a lot longer than it needs to be but it works.Please Login or Register to view this content.
the problem ive got is that i get this message come up for e very single sheet and dont want to be prompted
"data may exist in the sheet (s) selected for deletion. to permanantly delete the date press delete."
if anyone could help simply this code and the prompting problem it would be much appreciated.
kind regards
Bookmarks