Thanks for your reply. In this case, when I changed the code to reference named ranges, I had to unlock the worksheets prior to clearing the named ranges. Now it's working...