Note that since posting, I added a line in the Delete macro to prevent the build up of invalid Names (named ranges):
Names(theRange).Delete 'deletes the Name
Note that since posting, I added a line in the Delete macro to prevent the build up of invalid Names (named ranges):
Names(theRange).Delete 'deletes the Name
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote
