Nilem, I tried your code and it seemed to take about the same amount of time. It is a much cleaner way of writing it though, thank you for that.

Perhaps the code isn't the problem. Maybe instead it's the repercussions of the change. I do have several large data tables that reference the named range "Development Plan". I have the spreadsheet set to manual calculation while the macro runs, but perhaps that's not enough. I guess my understanding of Excel is not great enough to understand the full impact of some of these changes.