In my code to clear the workbook for a new period - I need to clear the contents of all named ranges on sheet12. (all cells are locked)
How can I have it clear the contents of each cell in the named range on sheet12. There are 42 named ranges. I do not want to clear the name of the range. I still need those.